Enables or prevents users from accessing query plans from the Interactive SQL (dbisql) client or from using SQL functions to get plans.
ON, OFF
OFF
DBA permissions are required to modify this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
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.
“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
“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)
