8 Index Access paths DB2 uses for SQL performance(1 of 2)

DB2 uses the following index access paths:

  • Matching-index scan (MATCHCOLS > 0)
  • Index screening
  • Nonmatching-index scan (ACCESSTYPE = I and MATCHCOLS = 0)
  • IN-list index scan (ACCESSTYPE = N)
  • Multiple-index access (ACCESSTYPE is M, MX, MI, or MU)
  • One-fetch access (ACCESSTYPE = I1)
  • Index-only access (INDEXONLY = Y)
  • Equal unique index (MATCHCOLS = number of index columns)

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.