I’ve used the SQL Optimizer before but today it simply refuses to work. I’ve tried rebooting, etc. and have the same results.
Within SQL Editor window highlight SQL code
Right click -> Optimize -> Optimize Current SQL
Database type = General (OLTP or mixed)
Search Depth = 1 (also tried 2)
Hit OK Button
Optimizer opens within TOAD IDE.
Explain Plan completes
Work starts to optimize
Then after a few seconds it errors
Error window popup…
"Failed to update scenario data file
Error adding SQL"
Press OK to clear popup
Popup re-appears MANY MANY times
After all errors cleared no alternative SQL to choose from, only Original SQL present within optimizer tab/window
Toad Version: 10.6.1.3 (Toad for Oracle Xpert)
Used simple SQL and more complex SQL, same result
Does anyone know where this “scenario data file” is so I can check the file access rights, etc?