Words of Wisdom
The one that spurred me into making a comment however was "Hinted SQL". I really liked this quote:
Hints can be very useful to solve urgent problems – but my general advice is (a) don’t use them as a first resort, (b) check whether the real problem is in the statistics (c) if you really need to hint your SQL, you probably need an average of at least one hint per table to lock in the execution path you expect and (d) assume that you’re going to have to revisit and retest any hinted SQL on the next upgrade.
(emphasis added by me)
Well said, of course if you've seen my short seminar bit "to hint or not to hint" you'd know why I say "well said"...
It is exactly what I say in conclusion during that talk. Well, almost, I state (c) a little differently, but I like Jonathan's way of saying it - so maybe I'll borrow that.