Toad World® Forums

Alternatives all have Total Elapsed of Zero?


Some of my SQL statements when I run them through the optimizer will often have one or more alternatives that all result in the Total Elapsed Time being zero.

I would like for the optimizer even though this was the selected goal there should be a secondary goal. After all, if all the statements have the same total elapsed time then you would most likely have a secondary goal of fewer resources and given that time is equal this would be the deciding factor in finding the best statement. Does anyone else agree with this?


Hi David,

Thank you for the submitting this suggestion. I think this is a valid suggestion and it will increase the usage of the product. I have added it to my enhancement list.

Thanks again,