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
sql
5 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.
Company, Operating Organization, Project, and Warehouse in a Logistics Data Model
A source-backed model of four ownership dimensions that are often confused in enterprise logistics applications.
Why a Copied Outbound Order Disappeared from the Default Dashboard
How inherited audit timestamps made a newly copied outbound order invisible to a time-windowed dashboard.
Optimizing a Slow MySQL Wave List Query: From Index Tests to a SQL Rewrite
How I investigated a slow WMS list query, reverted ineffective index attempts, and validated a much faster query structure.