Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recommendation for SQL Tuning Book

RE: Recommendation for SQL Tuning Book

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Mon, 13 Jan 2003 09:25:28 -0800
Message-ID: <F001.0052DDC7.20030113092528@fatcity.com>


The Pocket Reference has been helpful to many people. The book appears to be at least a handy summary of some relevant aspects of Oracle's documentation. However, various colleagues have convinced me that there are many statements in the book that you can disprove using careful tests.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas

-----Original Message-----
David
Sent: Monday, January 13, 2003 3:39 AM
To: Multiple recipients of list ORACLE-L

Question for those who have gone before...

Is there a consensus on the best book to use to teach myself SQL tuning under the cost-based optimiser, particularly the use of hints.

I have lots of experience under the rule-based optimiser, so I need hard-core info on use of hints and other features, not the general principles of SQL.

I have found "Oracle SQL Tuning Pocket Reference by Mark Gurry" which looks
like it will fit the bill. Does anyone have a better suggestion?

Thanks in advance.

David Jones
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jones, David
  INET: David.Jones_at_acnielsen.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 13 2003 - 11:25:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US