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 software upgrades that affect optimizer choices
New Adaptive Server features that change query plans
Changing tuning options such as the parallel degree, table partitioning, or indexing
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
