Since I live in Denmark, I can say it more directly: Don't read that
book. It's full of errors.
Mogens
Cary Millsap wrote:
Test the things you read, if they might make an important difference in the performance of your system. If you pay too much attention to /any/ book, you'll learn this the hard way. Judge what you read in the little SQL Tuning Pocket Guide very carefully.
Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba *
Upcoming events: - Performance Diagnosis 101: 6/22 Pittsburgh, 7/20 Cleveland, 8/10 Boston - SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ryan.gaffuri@xxxxxxx Sent: Friday, May 28, 2004 8:52 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: RE: Useful Oracle books
They are different types of books. Dan's book teaches a 'process' for mapping out SQL statements. Its applicable every where.
Guy Harrisons book is more 'ok we tried this and here is the result'. Most
of it is useful. Some disagree, but the section telling you to convert
updates to cursors with 'where current of' is inaccurate. The rest is good. I recommend reading it.
Both are useful. Dan's is better. Its a slow read... and not a reference
book. You need to read the whole thing. Guy Harrison's is more of a
reference book.
I also liked the little O'reilly SQL Tuning book. Nice little reference book
that you can flip through. Most everything in it is in the documentation,
but its condensed and easy to reference. It's cheap too.
Here is a list of recommended tuning books that a guy in Oracle Support
wrote. I worked with him. He knows what he is doing... Dan's book isn't on
it. I'm sure it will be.
http://www.amazon.com/exec/obidos/tg/listmania/list-browse/-/VL8CI2YJANX1/re f=cm_lm_dp_l_1/104-9801265-8991939
From: "Charu Joshi" <joshic@xxxxxxxxxxxxxx> Date: 2004/05/28 Fri AM 09:47:33 EDT To: <oracle-l@xxxxxxxxxxxxx> Subject: RE: RE: Useful Oracle books
---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------