Toad SQL optimizer not returning elapsed time

526 views Asked by At

I've got a SQL script I'm trying to run through the Auto Optimize SQL tool in Toad. I've created alternatives (313 of them), and have started testing them, but when I run more than one alternative at a time, I don't get an Elapsed Time value back for each tested alternative.

"Hide Slower Alternatives" is not checked; and I've checked in, and seen it run several of the selected alternatives that have a blank Elapsed Time.

My thought is that Toad is suppressing the value for some reason, but I can't find any documentation on why it would do so (and more importantly on how to turn off if it's doing so).

Any help in why the data is not presented, and how to get Toad to always fill in the Elapsed Time would be appreciated.

0

There are 0 answers