Question

What is a plan? Explain in detail.
​

Answer 1

Answer:

statement's execution plan is the sequence of operations Oracle performs to run the statement.

The row source tree is the core of the execution plan. It shows the following information:

1. An ordering of the tables referenced by the statement

• An access method for each table mentioned in the statement

• A join method for tables affected by join operations in the statement

Data operations like filter, sort, or aggregation

• In addition to the row source tree, the plan table contains information about the following:

• Optimization, such as the cost and cardinality of each operation

• Partitioning, such as the set of accessed partitions

• Parallel execution, such as the distribution method of join inputs

IF MY ANSWER IS NOT BAD THEN PLZ MAKE MY ANSWER AS BRAINLIST AND PLEASE MAKE MY ANSWER AS BRAINLIST ❤️❤️❤️❤️

Answer 2

Answer:

Hope it helps you

Mark me as brainliest if you liked my answer