Database
308 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
CAP Theorem
Theorem on Consistency, Availability, Partition tolerance trade-offs
Replication
Copying data between servers for redundancy
Time-Series Database
Database optimized for time-stamped data storage
Isolation Level
Degree of visibility between concurrent transactions
Transaction
Single unit of work that succeeds or fails completely
ORM
Mapping object-oriented code to database tables