Provides a function through which you can compare 2 execution plans.
Provides the SQL performance information by Plan hash value.
|SQL Plan Hash
|Plan Hash Value
|SQL Text Execution Count by Plan hash value (Sum)
|Elapsed Time/exec (Sec)
|SQL Elapsed Time by Plan hash value (Average per execution)
|CPU Time/exec (Sec)
|SQL CPU Time by Plan hash value (Average per execution)
|Wait Time/exec (Sec)
|SQL Wait Time by Plan hash value (Average per execution)
|Logical Reads/exec (blocks)
|The number of Logical IO Blocks by Plan hash value (Average per execution)
|Physical Reads/exec (blocks)
|The number of Physical IO Blocks by Plan hash value (Average per execution)
The mouse right-click menu is as follows. For more information, please reference “Appendix. Grid Mouse Right-Click Menu UI”.
|Full SQL Text
|Provides SQL Full Text.
|Downloads the grid content on an excel file.
|Makes a copy of the grid content.
|Show/ Hide Columns
|Selects the columns to be displayed on the grid.
|Enables the Filtering function.
|Multiple Sort On
|Sorts based on 2 or more column values.
|Saves the grid content as an image.
Provides the execution plan information before the change.
Provides the execution plan information after the change.
Provides the function for deleting a partition within the MaxGauge repository.
The window configuration is as follows.
|Set the period for deleting a partition.
l You cannot drop any partitions within the last 7 days.
|Select the target instance to delete.
|Select the target table to delete.
|Delete the partition.