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-predicatesRule of thumb: index for equality first—then for ranges.
Rule of thumb: index for equality first—then for ranges.