Filter Before You Rank and Aggregate: Taking a 27-Second Query Down to About One Second
How moving selective business filters ahead of window functions and dependent aggregates cut a paginated Oracle query from 27.49 seconds to about 1.40 seconds.
TAGTags
oracle
2 articles
When a Production Dashboard Shows Zero Despite Having Data
Replacing full-detail loading with database aggregation after a production dashboard timed out and left every counter at its initial zero.