Query Optimization

Reducing dashboard load time from 20s to 3s.

Synonyms:

Query performance tuning, SQL optimization

Defnition:
Query optimization improves performance using indexing, partition pruning, caching, and predicate pushdown.

Variations:
Database query tuning