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".
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center