Your Mission: Go fix ALL of the slow SQL in your application ASAP.

SQL is an extremely powerful language for us database geeks. Without completely understanding, or even caring how the database is going to resolve my query, SQL allows me to ask for data by describing it.  For example, “Give me the employees by department, sorted by salary” equates to:

The database, in this case Oracle, then decides exactly how to get me that data. Therein lies the catch for SQL: while extremely powerful, it puts your application at the mercy of the database engine. Studies have determined that 80% or more of database application performance problems result from poorly performing SQL.

So HOW do we fix this?  For several years now Quest customers have benefited greatly from the Quest SQL Optimizer technology via Toad or Quest Central.  Users were able to take an identified ‘BAD’ SQL statement, and the SQL Optimizer would automatically find the best performing re-write for you to use in your application.  However, how many applications use a single SQL statement?  We now have a solution that allows you to point the Quest SQL Optimizer to a collection of SQL statements and have them all batch optimized, or tuned, in one session.

Now, it’s as simple as telling the SQL Optimizer where your SQL is located.  This could be:
- database objects
- the source code files
- the SGA (Oracle)

The Quest SQL Optimizer will then examine the contents of these objects, take the risky SQL statements and auto-batch optimize them.  The re-writes will then be available for you to automatically send back to your original objects – not including the SQA of course J

Step 1: Find the Pesky Ill-Performing SQL


Choose the instance and where to look for SQL tuning candidates. 

Step 2: Press the Easy Button, in this ‘OK’!


The Optimizer will scan the objects, look for bad SQL, tune it, and present the results!

Step 3: Create Migration Script to implement the optimized SQL


Once you’ve examined the results, you can implement them for development or testing.

How to Get the new Quest SQL Optimizer.
This is available immediately for download from Quest.com to existing Toad for Oracle Xpert users or anyone else that has purchased the SQL Optimizer option for Toad or for anyone who has licensed the option from Quest Central.  Just login to Support at Quest.com and go to the updates page for ‘Quest SQL Optimizer’.

Do you see ‘SQL Optimizer’ in your Help > About for Toad? 

Are you not a current license-holder, but would like to download a copy for evaluation? You can get a trial standalone download.

For more information, try the following resources:
            ·          Quest SQL Optimizer User Community
         o         View a Flash Demo
            ·          Quest SQL Optimizer Product Page