Re: Reviews of Dan Tow's "SQL Tuning"?
Date: Wed, 14 Jan 2009 00:14:36 -0800 (PST)
Message-ID: <922534ad-7864-4074-861d-4e474498c81f_at_e22g2000vbe.googlegroups.com>
I liked Dan Tows book. Although I only made it three quarters through due to pressure of work and a change of role. It presents a useful means of conceptualising what the optimizer does without requiring as much analytical maths as Jonathans book. As it deals with concepts, it is not Oracle specific, but Oracle does get a few mentions. I read this after Cost Based Oracle : Fundamentals. I found I enjoyed CBOF more, though Dan Tows book gave me a different and useful way of thinking about the SQL optimization problem, as well as a graphical means of query representation . I'd recommend to someone new to Databases optimisers and even someone with experience looking to read around the subject.
I plan to go back and finish it off, but it's in the queue behind Opitimizng Oracle Performance, forecasting Oracle Performance and a reread of Cost Based Oracle - that is unless CBOF part two doesn't make it to the bookshelves in the meantime :0)
Best Regards
Steve Howard wrote:
> Hi All,
>
> My apologies if this should have gone in CDOM, but it seemed relevant
> here.
>
> I have seen several posts that mention this book as part of a reply,
> but I wanted to get a separate thread for it in case anyone has a
> string opinion on it one way or the other.
>
> http://www.amazon.com/SQL-Tuning-Dan-Tow/dp/0596005733/ref=pd_sim_b_6
>
> It seems pretty generic, so I wonder if it has value for an oracle
> specific user? It was printed in 2003, so is the methodology still
> relevant, especially for Oracle?
>
> Thanks,
>
> Steve
Received on Wed Jan 14 2009 - 02:14:36 CST