6 articles
Trace an HTTP 200 empty response to an Oracle invalid-identifier error, replace legacy WM_CONCAT calls with deterministic LISTAGG, and verify source, build, artifact, and overflow boundaries.
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.
Replacing full-detail loading with database aggregation after a production dashboard timed out and left every counter at its initial zero.
A source-backed model of four ownership dimensions that are often confused in enterprise logistics applications.
How inherited audit timestamps made a newly copied outbound order invisible to a time-windowed dashboard.
How I investigated a slow WMS list query, reverted ineffective index attempts, and validated a much faster query structure.