Access Methods (or Paths) are something totally related to the optimizer.
So, what you should study here are the access methods that are possible inside Oracle for either Tables, B-Tree Indexes, Bitmap Indexes or Clusters:
- Full Table Scans
- Table Access by Rowid
- Sample Table Scans
- Index Unique Scans
- Index Range Scans
- Index Full Scans
- Index Fast Full Scans
- Index Skip Scans
- Index Join Scans
- Bitmap Index Single Value
- Bitmap Index Range Scans
- Bitmap Merge
- Bitmap Index Range Scans
- Cluster Scans
- Hash Scans
You will only be good in this topic with practice. In my opinion, studying explain plans and access paths will only give you theory concepts (that serves for almost nothing in the OCM exam). Practice with daily work is the best approach for this topic.
Path to Documentation:
Performance Tuning Guide -> 11 The Query Optimizer
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!