Analyze Dynamic Parameters

Adaptive Server version 15.7 allows you to analyze dynamic parameters (which are indicated by question marks) before running a query, helping you avoid inefficient query plans.

Analyze the dynamic parameters using:

Using the value provided by @@plwpid as the value for the show_dynamic_params_in_xml object_id parameter, Adaptive Server displays information about the dynamic parameters in the query. Continue refining the query plan until you determine the parameters that provide you with the best query plan.

See "Displaying Query Optimization Strategies and Estimates" in the Performance and Tuning Series: Query Processing and Abstract Plans.