Database
38 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
Normalization
Organizing tables to reduce redundancy and improve integrity
Database Migration
Version-controlled changes to database schema
Partitioning
Dividing tables into smaller pieces for better performance
Replication
Copying data between servers for redundancy
Graph Database
Database optimized for entity relationship queries