OCM 11g Preparation - Administer and tune schema object to support various access methods

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 👍!

Leave a Reply

Your email address will not be published.