Could you suggest a good book for SQL tuning?

[dariyoosh]

Hello Tim,


I would like to ask you some advice about how to learn SQL tuning. It has been a while since I have been reading the online oracle documentation : "Oracle® Database Performance Tuning Guide 11g Release 2 (11.2)" and I've learnt several concepts. Yet, I really believe that regarding my current beginner level, the documentation is too advanced for me. I'm totally beginner in the field of tuning and performance. I'm not DBA for now, and I work with oracle rather as a SQL-PL/SQL developer, so the priority for me at the present is to master SQL and PL/SQL tunning (joins, execution plans, etc.). Of course once I become familiar with the basics I'd be glad to go further. So what I'm looking for is a really beginner friendly and up to date book.


I did the same while I wanted to learn PL/SQL, I took Steven Feuerstein's book which seemed to me more suitable for a totally beginner. Once I became more familiar with the stuff I started reading oracle online PL/SQL documentation which was then much more useful and comprehensible thanks to the background with the Steven's book.

So I try to proceed in the same way for learning oracle tuning (most importantly starting by SQL tuning).

Could you kindly give me some guidelines, Tim? (books, tutorials, etc.)

Thanks in advance,

Kind Regards,

Dariyoosh

[Tim...]

Hi.

I think Troubleshooting Oracle Performance, by Christian Antognini is an awesome book.

He considers himself a performance guy, not a DBA, so most of the book is focused on application tuning, rather than instance tuning.

If does go into quite a lot of detail, but the writing style is very accessible.

Cheers

Tim...

[dariyoosh]

Dear Tim,


Thank you very much for your advice. I've just checked on amazon.com and I saw that the book
is available in stock, so I think I'm going to purchase this one.

It seems to me that the book has been printed two times, once at June 2008 and last time at
December 2011 (still the 1st Edition), so it should be up to date.

So I'm going to read this and I will let you know if I progress

Once again, thank you very much for your kindness and your help


Kind regards,
Dariyoosh

[Tim...]

Hi.

Much of the advice in it is appropriate to all versions of the database anyway.

Cheers

Tim...