Indexing
Quick Definition
Creating data structures to speed up data retrieval
Full Definition
Creating data structures that speed up data retrieval operations in databases.
Examples
B-tree index, hash index, composite index, covering index
Related Terms
query-optimization
performance
More Database Terms
Read Replica
Copy of primary database for read-only queries
Query Optimization
Improving query performance through various techniques
Denormalization
Intentionally adding redundancy to improve reads
B-Tree Index
Self-balancing tree index for efficient sorted data operations
Normalization
Organizing tables to reduce redundancy and improve integrity
Replication
Copying data between servers for redundancy