#indexes

1 article tagged “indexes”.

A B-tree index narrowing a search from a million rows down to a single leaf page

SQLAdvanced

SQL Indexes and Query Plans: Making Slow Queries Fast

Learn how B-tree indexes really work, read query plans with EXPLAIN, choose the right column order for composite indexes, and spot the mistakes that silently disable an index.

Oct 29, 20268 min read