A query plan, also called an access plan or execution plan, gives you insight into the optimization strategy for a query. It evaluates the impact of query structure, use of subqueries, parallelism, indexes, number and width of columns used, amount of data and unique data in those columns, internal methods of scanning the data, algorithms for joins, ordering, grouping, unions, recursive unions, sorting, and search filters, and other factors.
Most of the information in the query plan is intended for use by experienced database administrators. See your server documentation to understand the plan details.
You can view a query plan for Adaptive Server Anywhere and Adaptive Server Enterprise queries in Sybase WorkSpace. In the Query Plan Preferences page you can choose from several options for displaying the plan, depending on your server version.
Setting ASA Query Plan Preferences
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com