Multi-column index keys
Other searches
B-tree index on (A, B, C)
- A = 2 and B = 7: Yes
- A = 2: Yes
- A = 3 and B = 8 and 2 < C < 10: Yes
- A = 3 and B > 2 and C < 5: No
- A < 9: Yes
- A < 9 and B = 5: No
- A = 3 and B > 5: Yes
Hash index on (A, B, C)
- A hash index can't do any of these searches.
|