You can think of an execution plan as the combination of steps used by the #database to execute an #SQL statement. In an execution plan, you can see the list of steps the database will have to perform to execute the statement, along with the cost associated with each step, which is very useful because you can see which of the steps are using more resources, and thus, probably taking more time to complete.

00:00 Execution Plan
08:56 How bad a plan might be?
12:21 How smart optimizer is!
19:09 Generate execution plan in Oracle
19:20 AUTOTRACE Easy option
20:41 Explain Plan

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis