Indexing
DBMS
A database optimization technique that creates a data structure to speed up data retrieval operations at the cost of additional write overhead and storage.
Tags
optimizationquery-performancestorage
Related Concepts
Caching
System Design
Storing frequently accessed data in a faster storage layer to reduce latency and database load. Common caching solutions include Redis and Memcached.
performanceoptimizationstorage
Normalization
DBMS
The process of organizing database tables to reduce redundancy and improve data integrity through a series of normal forms (1NF, 2NF, 3NF, etc.).
schema-designoptimizationfundamentals
SQL
DBMS
Structured Query Language. A standard programming language specifically designed for managing, querying, and manipulating data stored in relational da...
databasesqueriesstorage