Infrastructure
Database Index
An additional lookup structure that a database can use to locate relevant records more efficiently. Indexes consume storage and must be maintained when relevant data changes. The database planner may choose a different access strategy; creating an index does not guarantee every query becomes faster or that result ordering changes.
Reviewed
Sources
Member lesson
The definition and sources are public. The complete practical lesson is for members.