Existing SQL
Optimize SQL
Use Performance tune-up to receive a rewritten query with inline explanations of suggested improvements.
Steps
1
Add the existing SQL
Paste or upload the query in the Imported SQL workspace.
2
Select Performance tune-up
Choose the predefined performance task.
3
Compare the rewrite
Review the revised SQL and inline comments explaining material changes.
4
Validate with the database
Use execution plans, indexes, statistics, representative data, and normal performance testing.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.