Data and documents
SQL optimisationFaster applications and reports
Improving queries, indexes and database access to speed up applications and reduce unnecessary load.
Business applications
Slow screens and reports can block work. The cause may be locks, query shape, data volume or application access patterns.
How it fits into my work
I measure representative operations, inspect execution plans and validate targeted changes under comparable load.
Example scenario
SQL optimisation: Example scenario
A report is compared before and after a query change, checking both response time and result correctness.
Where should your company start?
Identify a slow screen, report or import. Provide sample data, timing and the load at which the problem occurs.
How will you know it helps?
Compare response time, result correctness and resource use on the same representative scenario.