Access Path I

• Starting with the most efficient

  • Single row by ROWID
  • Single row by cluster join
  • Single row by hash cluster key with unique or primary key
  • Single row by unique key
  • Cluster join
  • Hash cluster key
  • Indexed cluster key
  • Composite index
  • Single-column index

Notes: