When I try to optimize and execute a query, the results give an "Execution Error" in the grid. It seems to optimize fine and gives alternatives. The explain plan it run. But after clicking Execute to get run time stats, it only shows the execution erred out and does not give any stats. There is no further error info.
1. Run Quest SQL Optimizer for Oracle.
2. Run in either Batch Optimizer or Tuning Lab.
3. Optimize a long SQL query.
4. Runs through Execute but original and all alternates cannot be executed, only showing "Execution Error".
The issue is related to the size of the SQL when it is longer than 32767 bytes.
Issue fixed in version SQL Optimizer for Oracle 7.4. The latest version of SQL Optimizer for Oracle can be downloaded at: http://support.quest.com/support_download/Downloads.asp