![NEAREST_CENTURY option [TSQL]](arrow-left.gif){kind=icon}
Generates the optimizer query plans instead of executing the plan.
ON, OFF
OFF
DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
When determining how to process a query, the IQ optimizer generates a query plan to map how it plans to have the query engine process the query. If this option is set ON, the optimizer sends the plan for the query to the IQ message file rather than submitting it to the query engine. This option affects queries and commands that include a query.
NOEXEC ON also prevents the execution of INSERT...VALUES, INSERT...SELECT, INSERT...LOCATION, SELECT...INTO, LOAD TABLE, UPDATE, TRUNCATE TABLE, DELETE, SYNCHRONIZE JOIN INDEX, and updatable cursor operations.
When the EARLY_PREDICATE_EXECUTION option is ON, Sybase IQ executes the local predicates for all queries before generating a query plan, even when the NOEXEC option is ON. The generated query plan is the same as the runtime plan.
“EARLY_PREDICATE_EXECUTION option”
“GRAPHICAL_PLAN function [String]” and “HTML_PLAN function [String]” in Chapter 4, “SQL Functions” in Reference: Building Blocks, Tables, and Procedures
