Access Plan

Access Plan
The access plan or query plan is an ordered set of steps to access the data. Access plan lets you view the properties or statistics for a table, index etc. The optimizer produces an access plan whenever any SQL or Xquery gets compiled. To understand the access plan, it is important to understand the basic components of an access plan. The basic components of an access plan are:-
 * Cardinality
 * Plan Operator
 * Plan Operator ID
 * CPU Cost
 * I/O Cost

Analyzing Access Plan
There are several ways to explain a query access plan.

developerWorks Article
Tuning DB2 SQL Access Paths

Also See

 * Cardinality