Abstract plans

Adaptive Server can capture query text and save an abstract plan for a query in a new system table called sysqueryplans. Using a rapid hashing method, incoming SQL queries can be compared to stored query text, and if a match is found, the saved abstract plan is used to execute the query.

An abstract plan describes the execution plan for a query using a language created for that purpose. This language contains operators to specify the choices and actions that can be generated by the optimizer. For example, to specify an index scan on the titles table, using the index title_id_ix, the abstract plan says:

( i_scan title_id_ix titles)

Abstract plans provide a means for System Administrators and performance tuners to protect the overall performance of a server from changes to query plans. changes in query plans can arise due to:

Other uses include:

For information about using abstract plans, see Chapter 21, “Introduction to Abstract Plans,” in the Performance and Tuning Guide.