Optimize for Clause

Description

If this clause is omitted, it is assumed that all rows of the result table will be retrieved; if it is specified, it is assumed that the number of rows retrieved will probably not exceed n, where n is the value of an integer

The Optimize for Clause is not applicable in Snowflake

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

Grammar Syntax

Sample Source Patterns

IBM DB2

SELECT
   *
FROM
   Table1
OPTIMIZE FOR 2 ROWS

Snowflake

 SELECT *
 FROM
   Table1
 -- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
 -- OPTIMIZE FOR 2 ROWS

Known issues

MSCEWI1002: REMOVED STATEMENT, NOT APPLICABLE IN SNOWFLAKE.