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.