QUERY_PLAN_TEXT_CACHING option

Function

Allow users to specify whether or not Sybase IQ generates and caches IQ plans for queries executed by the user.

Allowed values

ON, OFF

Default

OFF

Scope

DBA permissions are not required to modify this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

IQ query plans vary in size and can become very large for complex queries. Caching plans for display on the dbisql client can have high resource requirements. The QUERY_PLAN_TEXT_CACHING option gives users a mechanism to control resources for caching plans. With this option turned OFF (the default), the query plan is not cached for that user connection.

NoteIf QUERY_PLAN_TEXT_ACCESS is turned OFF, the query plan is not cached for the connections from that user, no matter how QUERY_PLAN_TEXT_CACHING is set.

See also

“QUERY_DETAIL option”

“QUERY_PLAN_TEXT_ACCESS option”

“QUERY_PLAN_AS_HTML option”

“QUERY_PLAN_AFTER_RUN option”

“GRAPHICAL_PLAN function [String]” and “HTML_PLAN function [String]” in Chapter 4, “SQL Functions” in Reference: Building Blocks, Tables, and Procedures

“OUTPUT statement [DBISQL]”

“PLAN function [Miscellaneous]” in SQL Anywhere Server – SQL Reference > Using SQL > SQL functions > SQL functions (P-Z)

“EXPLANATION function [Miscellaneous]” in SQL Anywhere Server – SQL Reference > Using SQL > SQL functions > SQL functions (E-O)