Toad World® Forums

Sql Optimizer Module

I can run Auto Optimize SQL but I cant use the advanced sql optimizer. What am i missing? I have the
xpert Edition
Add-ons DB Admin
There is not another license I need is there?

Thanks
Dave

Is Quest SQL Optimizer installed? It may have been an option when you installed Toad.

honestly not sure, toad is installed by out software team, how can i check

I don't have it installed so I'm not 100% sure, but I guess it would be under program files somewhere.

Or you can search your hard drive for QSOOLauncher.dll. If you don't have that, it's not installed.

so not installed? image

That QOraOptEngineLib.dll is what's used in the "Auto Optimize SQL" window. Those others are unrelated.

I think QSOOLauncher.dll will be in a different folder, if it exists. Search the disk, or at least everything under Program Files (or Program Filesx86)

from dos, go to the top folder, then 'dir QSOOLauncher.dll /s /p' to search all subfolders.

dont see that file

C:\Program Files\Quest Software\Toad for Oracle 13.1>dir QSOOLauncher.dll /s /p
Volume in drive C is OS
Volume Serial Number is 0C2
File Not Found

That's why it's not enabled.
Check with whoever installed it. See if that was an option. It's a separate product but it may have been bundled with Toad.

cool thanks, maybe ill see if someone can just download 13.2 and install it for me

so no way to just get that bundle?

This is what you are looking for:
https://support.quest.com/sql-optimizer-for-oracle/9.2.3 (login required)

You can just install that w/o having to reinstall Toad. You will have to restart Toad afterwards for it to re-check for SQL Optimizer.

that msi worked, I didnt realize its "like" a separate software

1 Like