SQL Plan
The users can view the execution plan of the created SQL. If The users need to tune the query, The users can do so to create the optimal SQL statement. The execution plan information is read from top to bottom, from inside to outside, starting with the task with the most indentation.
The execution plan is available in two views: Tree and Text.
Plan Info
The users can check the SQL ID, CHILD NUMBER, HASH VALUE, PLAN HASH VALUE, and executed SQL information related to the plan.
Tree View
It displays the plan information in the form of a tree in the left area, and when The users focus on a specific row, the detailed plan information of the focused row is displayed in the right area.
The main columns are as follows.
Operation
Indicates the specific operation performed by the database.
Option
Provides additional details about the operation
Object
The database object on which the operation is performed
Cost
The relative cost to run the query
Cardinality
The number of rows the job is expected to return
Partition State
The partition to start scanning
Partition Stop
The partition to end the scan on
CPU Cost
CPU usage cost
IO Cost
Disk I/O cost
Access Predicate
Conditions that determine how data is accessed
Filter Predicate
Conditions that filter data after it is read
Text View
Displays the contents of all plans in the editor as text.
Last updated