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?