Access paths and their ranking |
Path 1 |
Single Row by Rowid |
Path 2 |
Single Row by Cluster Join |
Path 3 |
Single Row by Hash Cluster key with Unique or Primary Key |
Path 4 |
Single Row by Unique or Primary Key |
Path 5 |
Clustered Join |
Path 6 |
Hash Cluster Key |
Path 7 |
Indexed Cluster Key |
Path 8 |
Composite Index |
Path 9 |
Single-Column Index |
Path 10 |
Bounded Range Search on Indexed Columns |
Path 11 |
Unbounded Range Search on Indexed Columns |
Path 12 |
Sort-Merge Join |
Path 13 |
MAX or MIN of Indexed Column |
Path 14 |
ORDER BY on Indexed Column |
Path 15 |
Full Table Scan |