QUERY_PLAN_TEXT_ACCESS option

Function

Enables or prevents users from accessing query plans from the Interactive SQL (dbisql) client or from using SQL functions to get plans.

Allowed values

ON, OFF

Default

OFF

Scope

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

Description

When QUERY_PLAN_TEXT_ACCESS option is ON, users can view, save, and print query plans from the dbisql client. When the option is OFF, query plans are not cached, and other query plan-related database options have no affect on the query plan display from the dbisql client. The following error message displays:

No plan available. The database option QUERY_PLAN_TEXT_ACCESS is OFF.

See also

“QUERY_DETAIL option”

“QUERY_PLAN_AS_HTML option”

“QUERY_PLAN_AFTER_RUN option”

“QUERY_PLAN_TEXT_CACHING 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]”

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

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