Indexing Strategies for Faster Database Queries
TL;DR
Indexes = direct lookups — milliseconds vs full table scans (seconds).
B-tree for most queries — Supports =, <, >, BETWEEN, LIKE 'prefix%', ORDER BY.
Index WHERE / JOIN / ORDER BY columns — O
cloudwithsw.hashnode.dev10 min read