The QP Tune utility enables you to identify the most optimal query plan, optimization goals, and other configuration settings and apply them at the server or query level. QPTune allows you to:
Fix missing statistics in an application
Tune an application to find the best optimization settings for any number of queries
Selectively apply standard or customized settings to specific queries using user-defined rules
For more information on how to optimize performance and on how to use the QPTune GUI interface see the Migration Technology Guide for Adaptive Server 15.0.3.