I am trying to run Quest SQL Optimizer 8.8.1 for Oracle on a fairly complex SQL statement of ours, to see how much improvement can be made by the tool. I’m trying to run the tool using the “Batch Optimize SQL”, however it seems to get stuck on “Searching for SQL 22%” in the Job Status and doesn’t get any further. I’ve left the job running overnight and the status hasn’t changed, nor found a single alternative SQL statement. Total "Number of SQL by Classification : 0 ".
Can anyone tell me what i’m doing wrong and how I can get SQL Optimizer to recommend the best alternative for a “fairly complex” SQL statement?