SQL tuning GOOD book recommendation ?

Printable View

06-19-2003, 04:56 PM
khussain

SQL tuning GOOD book recommendation ?

Can anyone recommend a good SQL Tuning perf. book, that cover DBMS_STATS options in details, etc, etc.

Most of the ones I have thumbed thru talk about how to gather stats, but not what all the options mean, and what is the preffered way to analyze: example: for all columns, or for all index columns, etc, etc.
06-20-2003, 03:00 AM
Tarry

A combination of these 2 books is the best that I can think of...
http://www.amazon.com/exec/obidos/AS...246170-3273738
06-20-2003, 03:21 AM
DaPi

I too would recommend Guy Harrison's book. (Tom Kyte's long-awaited, but yet unpublished, new book is likely to be a good bet.)
06-20-2003, 05:22 AM
efrijters

mr DaPi:

Which book of Tom Kyte are you referring to? A new version of Expert one-on-one? I would really want one that also covers Oracle9i...
06-20-2003, 08:08 AM
DaPi

Here is a preview:
http://asktom.oracle.com/pls/ask/f?p...8145042756282,
06-20-2003, 09:23 AM
khussain

Guy Harrison's book "Oracle SQL High-Performance Tuning " was published in Dec 2000 ! Those who have it: Are you recommending it for the explaination of the concepts, not necessarily for the implementation of Oracle options ?

Also, I have Tom Kyte's book, and it does not have what I am looking for either !
06-20-2003, 09:33 AM
Giani

Quote:

Originally posted by khussain

Also, I have Tom Kyte's book, and it does not have what I am looking for either !

That's why Tom Kyte's site exists to help him improving his book:D :) ;)
06-20-2003, 10:33 AM
DaPi

Quote:

Originally posted by khussain
Guy Harrison's book "Oracle SQL High-Performance Tuning " was published in Dec 2000 ! Those who have it: Are you recommending it for the explaination of the concepts, not necessarily for the implementation of Oracle options ?

Also, I have Tom Kyte's book, and it does not have what I am looking for either !

Go for the concepts; the details will come with a little RTFM. Three chapters of Harrison's book would have fixed nearly every performance prob I've seen posted here.

Don't see how you can have Kyte's new book - it's not published yet!
06-20-2003, 10:43 AM
khussain

Quote:

Originally posted by DaPi
Don't see how you can have Kyte's new book - it's not published yet!

I did not say I had his NEW book, I am talking about his old book, Published 2001.
06-20-2003, 11:56 AM
khussain

The asktom site is great... I was able to learn a lot from the examples that he gives - great.
06-20-2003, 02:10 PM
dharma

Also check out Don Burlesons SQL Tuning
-dharma
06-21-2003, 07:49 PM
afshin

Hi

This book is a good one if u r on Unix

http://www.amazon.co.uk/exec/obidos/...611663-7305258

There has been tons of discussions on this subject here mate, just search on this forum . U will be alright then .

cheers
afshin
:o