LearningCausesv1

A database index speeds selective lookups

An ordered auxiliary structure avoids scanning every row.

Reddit
Output
Fewer examined rows and a faster query
Input
A query filtering a large table by an indexed column
Relationship

What connects the input and output?

The database traverses the index to locate matching row references, then reads only the required records.

Sources

1
  1. dev.mysql.com: A database index speeds selective lookupsdev.mysql.com

Discussion

0

Sign in to join the discussion.