Toad World® Forums

SQL Optimizer 'alternatives' exports?

Does anybody know if there is a way to tell SQL Optimizer to export it’s
‘alternatives’ to a simple text file?

The reason I ask is because we use ‘authorization is external’ for our
user/schemas and SQL Optimizer does not support that. This effectively makes SQL
Optimizer worthless for me. But, if it could write out all the alternatives to a
script, I could run them that way.

Regards,

Mike

On a side note - have you tried the option to optimize the statements inside of
Toad? Since it runs inside of Toad, you might get more value.

Yes, that also requires a database connection with a non-null password.

Regards,

Mike

On Wed, Apr 20, 2011 at 1:13 PM, Jeff Smith wrote:

On a side note - have you tried the option to optimize the statements
inside of Toad? Since it runs inside of Toad, you might get more value.

Jeff, I haven’t tried it yet, but would love to get familiar/hang on with it
because I am the Administrator of Toad in the company (we bought 28 Toad Oracle
Xpert licenses, many of developers are new to Toad). I’ll read the Toad quick
guide to learn how to optimize the statement inside of Toad. Thanks for all
info.

Lisa

It runs in a Toad connection…although I haven’t tested it myself. Are you
saying it doesn’t work for EXTERNAL OS authenticated users?

Jeff,

yes, that is what I am saying. I believe it tries to create
an additional session which requires a login. It apparently tries to do it
‘under the covers’ but when it finds that it is an EXTERNAL, it raises
an error saying something to the effect that a NULL password is not allowed.

Mike

On Wed, Apr 20, 2011 at 5:22 PM, Jeff Smith wrote:

It runs in a Toad connection...although I haven't tested it myself. Are
you saying it doesn't work for EXTERNAL OS authenticated users?

Sounds like a bug. I’ll check it out.

Michael

On Apr 21, 2011, at 6:18 AM, “Michael Moore” wrote:

Jeff,

yes, that is what I am saying. I believe it tries to create an additional
session which requires a login. It apparently tries to do it 'under the
covers' but when it finds that it is an EXTERNAL, it raises an error saying
something to the effect that a NULL password is not allowed.

Mike

On Wed, Apr 20, 2011 at 5:22 PM, Jeff Smith wrote:

It runs in a Toad connection…although I haven’t tested it myself. Are
you saying it doesn’t work for EXTERNAL OS authenticated users?