SQL and Access Paths › Access Paths

Access Paths

DB2 can use the following access paths when accessing the data in your database:

• Tablespace Scan
• Limited Partition Scan
• Index Access
• List Prefetch
• Nested Loop Join
• Hybrid Join
• Merge Scan Join
• Star Join

The access paths are exposed using the EXPLAIN facility. You can invoke the EXPLAIN facility using one of these techniques:

• EXPLAIN SQL statement
• EXPLAIN(YES) BIND or REBIND parameter
• Visual EXPLAIN
• Optimization Service Center