Duration: 16:58 min
Summary: Every DML command received by Oracle is executed after a generation of its execution plan. This plan is the sequence of internal steps needed to perform the action demanded by the SQL statement and returns a set of rows of just information about its execution state. This video explains the details of the execution plan and shows how to generate an execution plan for a SQL statement. The commando EXPLAIN PLAN is shown in the examples along with the description on the main information need to understand the execution plan. The video also cite common operations found on the execution plan.