| Author |
Good book on Oracle SQL tuning
|
|
| nickli 2005-04-24, 1:23 pm |
| Hi,
Could anyone suggest a good book on Oracle SQL performance tuning?
Thanks in advance.
Nick Li
| |
| IANAL_VISTA 2005-04-24, 1:23 pm |
| "nickli" <ningli2000@hotmail.com> wrote in
news:1114364349.257396.5350@z14g2000cwz.googlegroups.com:
> Hi,
>
> Could anyone suggest a good book on Oracle SQL performance tuning?
>
> Thanks in advance.
>
> Nick Li
>
>
Oracle Performance Tuning 101 ISBN: 0072131454
Optimizing Oracle Performance ISBN: 0-596-00527-X
SQL_TRACE & TKPROF are a SQL tuner best friends
| |
| Mark D Powell 2005-04-25, 11:23 am |
| I haven't read either of the books listed by ianal_vista but SQL Tuning
by Dan Tow is interesting. It is an attempt at creating a mathematical
(graphical) methology for tuning queries that should work for SQL using
any relational database manager.
I have some disagreement with some of the points in the book but I
recognize a lot of merit in it also. The book does not teach SQL and
in fact very little SQL appears in the book. Rather the book talks
about the method. This book is probably best suited for people who
have already read a book on tuning or made a fair number of attempts at
tuning and feel the approaches they have tried are not working well
enough.
HTH -- Mark D Powell --
|
|
|
|