Just been to great Madgex talk on SQL optimisation. Sometimes you need someone to show you how much you don't know about a subject.