SQL Optimizer scenarios

Toad for Oracle & DevOps Toolkit
1

Hi,

I’ve got a SELECT statement and I clicked on OPTIMIZE SQL. The Optimize window opens and the Optimizer does it’s thing.

BUT, I have only one scenario (the Original SQL). Why don’t I have more scenarios?

Thanks,

Marc.

2

Which of the various optimizers are you using? There are 3 ways for you to
optimize from Toad. Are you using the button to optimize current SQL? This
method opens a new Toad tuning window. Or, are you sending the statement to SQL
Optimizer? SQL Optimizer is a full blown optimizer that is a separate Quest
product. If you are using the optimize current SQL feature then look below the
grid showing the results. There is a checkbox to show all results. If that is
unchecked then only those scenarios that execute faster will be displayed.

Michael

3

Did you press the rewrite or generate indexes button?

It doesn’t really do its thing until you hit one of those buttons.

4

Hi,

This is how I use it, look at the files...

Thanks,

Marc

Sql Optimizer_2.jpeg
Sql Optimizer_2.jpeg1152×691 165 KB

5

Hi,

This is how I use it, look at the files...

Thanks,

Marc

Sql Optimizer_1.jpeg
Sql Optimizer_1.jpeg807×460 121 KB

6

Click in the SQL Text field

Then click on the ‘Optimize’ button.

FYI – you’re on an older version, so you may want to upgrade if
that’s available to you.

7

Hi;

I would like to know each are the MySQL pamameters to modified into the file
“My.cnf” to increase the perfmance of a web application PHP5.
My server is Ubuntu Linux with 8 Go RAM and 8 CPU.

Regards

8

There is a TOADMYSQL community for MySQL related questions…although you
may want to go to a dedicated MySQL community for that particular question since
it has nothing to do with Toad.