Skip to main content

4. Explain the Output

Optimization Summary​

The summary results display includes:

  • Number of executed SQLs

  • Number of rewrote optimizations

  • Number of SQL auditing rule violations

  • Recommended indexes

  • Overview of individual SQL optimization

Optimization Details​

For each SQL query, PawSQL will provide optimization details to show you *WHAT* and *HOW* the query is tuned, *HOW MUCH* does its performance improve and etc. There are *FIVE* sections in this query level tuning details, as follows.

  • Original SQL: The original SQL statement you are optimizing.

  • Rewritten SQL (if any): If the SQL statement has been rewritten, this shows the rewritten SQL statement.

  • Recommended Index (if any): If there is a suggested index, the details of the index are displayed here.

  • Validation Details (if what-if validation is set): If what-if validation is performed, this shows the details of the validation, including:

    • Performance improvement percentage: The percentage difference in performance between the optimized and unoptimized SQL statements.

    • Execution plan before optimization: The execution plan of the SQL statement before optimization.

    • Execution plan after optimization: The execution plan of the SQL statement after optimization.