Great points Krishna Indian. Just wanted to expand just a little bit on your points.

As far as situations dictating which is faster, is absolutely right. And it definitely is whether the subquery...