![]() ![]() Its definition is similar to the PLAN_TABLE. V$SQL_PLAN contains the execution plan for every statement stored in the shared SQL area. ![]() In addition to running the EXPLAIN PLAN command and displaying the plan, you can use the V$SQL_PLAN views to display the execution plan of a SQL statement:Īfter the statement has executed, you can display the plan by querying the V$SQL_PLAN view. The results also help you to understand the optimizer decisions, such as why the optimizer chose a nested loops join instead of a hash join, and lets you understand the performance of a query. The EXPLAIN PLAN results let you determine whether the optimizer selects a particular execution plan, such as, nested loops join. Parallel execution, such as the distribution method of join inputs Partitioning, such as the set of accessed partitions ![]() Optimization, such as the cost and cardinality of each operation In addition to the row source tree, the plan table contains information about the following: The tree shows the following information:Īn ordering of the tables referenced by the statementĪn access method for each table mentioned in the statementĪ join method for tables affected by join operations in the statementĭata operations like filter, sort, or aggregation The row source tree is the core of the execution plan. A statement execution plan is the sequence of operations that the database performs to run the statement. The EXPLAIN PLAN statement displays execution plans chosen by the optimizer for SELECT, UPDATE, INSERT, and DELETE statements. ![]()
0 Comments
Leave a Reply. |