As the topic before, execution plans are another thing that just the practical experience will give you knowledge. Studying through docs is not a good approach to learn that, at least for me.
After you get the basic concepts, try to check and understand what and why is happening.
Study also:
- Creating Plan Table.
- Set explain from SQL*Plus.
- Explain and get results using DBMS_XPLAN.
- Dictionary views with Plan information.
Path to Documentation:
Performance Tuning Guide -> 11 The Query Optimizer
Performance Tuning Guide -> 12 Using EXPLAIN PLAN
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!