Read Oracle SQL Execution Plan | DBMS XPLAN

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: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis