Why Your DBA Hates You by John Watson

Who tunes SQL – the developer or the DBA? There are some SQL constructs that are known to be inefficient and others that will confuse the heck out of the optimizer.

Your DBA will (or should) be looking out for them, but it’s better to identify and avoid them in the first place