Database
309 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
Referential Integrity
Constraint ensuring table relationships remain consistent
Cursor
Database object for traversing result sets row by row
DynamoDB
Fully managed serverless NoSQL database by AWS
Denormalization
Intentionally adding redundancy to improve reads
Materialized View
Physical stored copy of query results refreshed periodically
Cassandra
Distributed NoSQL database with high availability and scalability