Database
159 views
Query Optimization
Quick Definition
Improving query performance through various techniques
Full Definition
Improving database query performance through index usage, rewriting, and analysis.
Examples
EXPLAIN plans, index tuning, query rewriting, join optimization
Related Terms
indexing
performance
sql
More Database Terms
NoSQL
Non-relational databases with flexible data models and scaling
CAP Theorem
Theorem on Consistency, Availability, Partition tolerance trade-offs
ORM
Mapping object-oriented code to database tables
Isolation Level
Degree of visibility between concurrent transactions
ACID
Properties guaranteeing reliable transaction processing
Read Replica
Copy of primary database for read-only queries