Abstract Query Plans

Abstract plans were introduced in release 12.0 as 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 may be due to:

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.

For more information on abstract query plans, see the Performance and Tuning Guide. For a quick overview of how to use abstract query plans to troubleshoot performance problems after upgrade, see the TechNote Using and Maintaining Abstract Query Plans