Hash index не sorted — не помогает range (<, BETWEEN), ORDER BY, partial LIKE.
Разбор
- Только equality predicates на полный hash key.
- «Employees younger than 40» — hash useless.
- Hot spots при poor hash distribution.
- Не replacement для general-purpose B-tree.
Итог
Hash = equality only; no range/sort support.
