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 — Otherwise fu...»