Indexing SQL range conditions less than, greater than and between

use-the-index-luke.com/sql/where-clause/searching-for-ranges/greater-less-between-tuning-sql-access-filter-predicates

Rule of thumb: index for equality first—then for ranges.

# sql
414.