Query structure
Review whether repeated work, unnecessary complexity, or the arrangement of the query can be simplified.
SQL Optimization
Review and optimize pre-existing SQL before using it in your database
Add your existing SQL to the Imported SQL workspace and select Performance tune-up. SQL Mocker returns a rewritten query with inline comments explaining where changes were made and why they may improve performance.
Performance tune-up workflow
From uploaded SQL to a reviewable optimization
- 01
Add your existing SQL
Paste the query into the Imported SQL workspace or upload it as a SQL or text file.
- 02
Select Performance tune-up
Choose the predefined task beneath the assistant to request a performance-focused rewrite.
- 03
Review the suggested SQL
Compare the rewritten query with the original and read the inline comments explaining the proposed improvements.
- 04
Validate in your database
Test the query with your database execution plan, representative data, and normal review process before using it.
What the assistant reviews
Make potential improvements easier to inspect
Joins and filters
Inspect how joins, filtering, grouping, and intermediate result sets may affect the work performed by the query.
Explained improvements
See why each material change was suggested through inline SQL comments and assistant guidance.
Performance tune-up request
Optimize this SQL for performance.
Rewrite the SQL and add inline comments
showing where improvements were made and why.A revised query with context
The response includes usable SQL plus comments that make the proposed changes visible, so you can compare, question, or refine them before testing.
Validate before use
Optimization suggestions are not a substitute for database testing
SQL Mocker does not execute the query against your production data through this workflow. Actual performance depends on factors such as indexes, execution plans, table statistics, data distribution, and database configuration.
- Compare the revised SQL with the original query.
- Test with a representative execution plan and workload.
Ready to review your SQL performance?
Add your query to the Imported SQL workspace and select Performance tune-up.