Recommend an Oracle query optimisation book or course
Can anyone recommend a book on oracle query optimisation and/or recommend a course?
Bit of background:
This year's task is to optimisation a few oracle SQL reports - ok may be a couple of hundred.
I can see obvious optimisations, but there are some reports that are slow and I need to work out it that are just slow or if it is the 'query execution plan' for them than is none to clever. So I need to understand oracle's EXPLAIN PLAN output.
Currently using oracle 8 but will be moving to 9 or 10 later this year it that makes any difference.
Thanks