QUERY OPTIMIZATION

Description

Specifies whether the constraint or functional dependency can be used for query optimization under appropriate circumstances.

Click here to navigate to the IBM DB2 docs page for this syntax.

ENABLE QUERY OPTIMIZATION Constraint attributes are removed because they are not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
COL2 VARCHAR(10),
CONSTRAINT ConstraintName UNIQUE (COL1, COL2) ENABLE QUERY OPTIMIZATION
);

Snowflake

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
COL2 VARCHAR(10),
CONSTRAINT ConstraintName UNIQUE (COL1, COL2)
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--                                               ENABLE QUERY OPTIMIZATION
);

Known issues

There are no known issues.