Illustrative investigations
SQL tuning examples
Follow the reasoning from a slow-query report to the plan and schema evidence needed for a safe test. Results depend on real data, workload and server configuration, so these examples do not promise a speedup.
Slow order-history query
Investigate a customer filter with recent-first ordering and evaluate a composite-index hypothesis.
Slow deep-pagination query
Compare offset and keyset pagination while preserving the application’s ordering and navigation requirements.