How to Auto-Optimize SQL Code - New videos on Toad for Oracle Xpert Edition

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.

  1. Choose the portion of SQL on which you want to run Auto Optimize, then set parameters.
  2. Click OK.
  3. 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: