RE: oracle can ignore hints

Hi Dan

I could perhaps have been clearer.  That the book has been infuriating me is 
definitely *not* intended as implying that it is a bad book, it is my emotional 
reaction to it, and anyway I *like* books that infuriate and challenge me to 
think, even if I end up rejecting the ideas as wrong (and I am definitely not 
at that stage) being wrong in a sensible and logical manner is always 
educational.In any case the book is worth the price of entry alone for the 
following as early as page 4. 

<quote>
There are 3 steps to sql tuning

1. find out which execution plan you are getting
2. change the sql or database to get a different execution plan
3. find out which plan is best. 

</quote> 

Followed by the (hopefully obvious) discussion of the illogicality of the order 
of this approach. Stated like this it is obvious that most tuning efforts are 
at best wasteful of effort (and indeed could probably be done better by 
software which is great at trying hundreds or thousands of possibilities in a 
scattergun approach). 

Please don't take my comments as overly negative. 

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805 

P.S. I won't be commenting on the book in this public forum anymore - but I did 
think as it was possible that I seemed harsh on Dan in public I should try to 
clarify in public as well. 



        


**********************************************************************
This email contains information intended for
the addressee only.  It may be confidential
and may be the subject of legal and/or
professional privilege.  Any dissemination,
distribution, copyright or use of this
communication without prior permission of
the sender is strictly prohibited.
**********************************************************************

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: