Toad World® Forums

Alternatives all have Total Elapsed of Zero?


#1

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?


#2

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,
Alex