Database Category
INDEX
Data structure that speeds lookups.
Definition
A database index improves query performance by storing ordered references to rows, reducing the need for full-table scans.
Practical Example & Use Case
Adding a composite index on `tenant_id` and `created_at` can dramatically reduce response time for timeline queries in multi-tenant apps.
Editorial review date: 2026-03-13