The Optimizer Diagnostic Utility

Adaptive Server version 15.7 includes the sp_opt_querystats system procedure, which allows you to analyze the query plan generated by the Adaptive Server optimizer and the factors that influenced its choice of a query plan.

This analysis helps determine if elements in the query or the execution environment affect how Adaptive Server executes the query and its performance. You need not run the selected query to perform the analysis.

sp_opt_querystats provides this information:

You must install and configure the Job Schedule to run sp_opt_querystats.

See "Controlling Optimization" in the Performance and Tuning Series: Query Processing and Abstract Plans.