这个SingleOrDefault()优化是值得的，还是会造成过大的伤害?

I was messing around with LinqToSQL and LINQPad and I noticed that SingleOrDefault() doesn't do any filtering or limiting in the generated SQL (I had almost expected the equivalent of Take(1)). I was messing around with LinqToSQL and LINQPad