Infrastructure
Database Index
An index is an extra lookup structure a database keeps so it can find matching entries without reading every single one. Without an index, a search means scanning the whole list from top to bottom. Indexes make searching fast and saving very slightly slower, so you add them where people actually search.
This entry has not yet received a source-reviewed lesson update.
Member lesson
The definition and sources are public. The complete practical lesson is for members.