What if you could automatically tune your SQL in as few as two clicks? Think of how quickly you could improve performance and how easily you could learn to write better SQL.
We built the Auto Optimize function into Toad for Oracle Xpert Edition to simplify the very common task of rewriting SQL. Auto Optimize automates the process of evaluating hundreds or thousands of rewrites to your SQL statements and presents the best candidate alongside of the original so you can see the difference in performance.
- Choose the portion of SQL on which you want to run Auto Optimize, then set parameters.
- Click OK.
- In seconds, Auto Optimize rewrites your SQL and executes as many alternatives as you’ve specified.
Auto Optimize rates the performance of each rewrite by time elapsed, CPU cycles, I/O and more than a dozen other metrics. Each rewrite has a unique execution plan, and the best performing rewrite appears alongside your original SQL so you can study it.
Watch this 3-minute video of our John Pocknell demonstrating how to use Auto Optimize:
Auto Optimize makes it easy to tune SQL, a task that can consume a lot of a database developer’s time.
This is part 4 of my 5-part video series designed to help you decide whether Toad for Oracle Xpert Edition is right for you. If you want to find out more about Auto Optimize, have a look at Reason #1 in “Five Ways Toad Xpert Edition Can Help You Write Better Code,” our updated technical brief.
Want to see for yourself how Toad can help you tune your SQL in just a couple of clicks? Download a 30-day trial and take Toad Xpert Edition for a test drive.