Data and documents
SQLFaster applications and reports
A language for reading and modifying relational data, used in reports, integrations and analysis.
Business applications
Reliable queries support operational reports and data exchange. Their correctness, access scope and performance affect daily work.
How it fits into my work
I develop queries and data models, assess execution plans and verify changes on representative operations.
Example scenario
SQL: Example scenario
A report joins cases and payments, using agreed date rules and indexes to return consistent results.
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.