How to reset the SQL Optimizer options settings? Is there an option to reset the preferences back to default?
1) Full exit SQL Optimizer.
2) Go to Start | Run | type: regedit | press enter. NOTE: Please make a backup of your registry before making any changes.
3) Go to HKEY_CURRENT_USER\Software\Quest Software\Quest SQL Optimizer for Oracle\X.X.x (where X.X.x is the version).
4) Rename the “X.X.x” to “X.X.x _OLD”.
5) Close the Registry Editor.
Launch Optimizer and the preferences will be reset.
Enhancement request ST92562 has been submitted to Development for consideration in a future version of SQL Optimizer for Oracle.