index search
In a query plan, a step that starts from a key in an index and reads only the matching rows.
In more detail
SQLite shows it as SEARCH table USING INDEX name (column=?). Seeing it confirms the index you created is actually being used for that query.
Related terms
- table scan — Reading every row of a table to find the ones that match, instead of jumping to them through an index.
- query plan — The step-by-step route the database has chosen to answer a query: which tables to read, in what order, and with which indexes.
- index — A separate, sorted structure a database keeps alongside a table so it can find matching rows without reading them all.
Taught in
- Reading An EXPLAIN Plan — PostgreSQL, Indexing & Relational Data Modeling