| 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 |