Running an EXPLAIN PLAN is a fairly straightforward process.
- After the PLAN TABLE has been created, we must populate it with access path information by running the SQL statement prefaced with the following:
EXPLAIN PLAN SET STATEMENT_ID = ‘test1’
FOR <<ADD YOUR SQL HERE >>
- Once the access path information has been created, we run the plan.sql script, and analyze the output.
The following SlideShow will demonstrate the process.
Now that we have a broader understating of how to use the EXPLAIN PLAN, let us try out our new skills by seeing how to detect full-table scans.