Database
158 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
Schema Design
Defining database table structure and constraints
Trigger
Special procedure that auto-executes on table events
Primary-Replica Architecture
Architecture with primary for writes, replicas for reads
Database
Organized collection of structured data for storage and retrieval
Graph Database
Database optimized for entity relationship queries
Partitioning
Dividing tables into smaller pieces for better performance