Investigate a slow query with its planUse the actual database engine, schema and query plan to propose a testable optimisation without inventing a speed-up.sqlperformancetesting