Working with analysis tools and the Statistics Advisor when using the no-charge features in the Query Tuner Workflow Assistant

To tune an SQL statement, you can format the statement for better readability, generate a diagram of the access plan of the statement, and run the Statistics Advisor to generate RUNSTATS commands for collecting statistics on the tables and indexes that are in the access plan.

Feedback