Missing "One-Click Auto Optimize" button?

Hi again,

I’ve just installed the last version of Toad for Oracle Professional ( and with it, I was expecting to be able to use the “One-Click Auto Optimize” feature. Howerver, when I click on the button drop down, I only get 2 options “Advanced SQL Optimization” and “Oracle Tuning Advisor”.

Is there something else I need to do before the “One-Click Auto Optimize” button becomes visable?



You must buy/have license for Toad Xpert edition to get SQl Otpimzier and single statement or auto tune - which is just a GUI built in Toad to make using SQL Optmizer easier

Thanks Bert, that makes sense seeing that I’ve only got the trial version of Quest SQL Optimizer 8.8.1 for Oracle.