Re: Book Review: "SQL Tuning" by Dan Tow

Martha Stewart called it a Good Thing when "Bob Badour" <bbadour_at_golden.net> wrote:
>> you mean this book? Is it really any good? Looks like inter-database stuff
>> and that is always watered down.
>>
>>
> http://www.amazon.com/exec/obidos/tg/detail/-/1558607536/qid=1073013652//ref
>> =sr_8_xs_ap_i2_xgl14/002-7457171-4222439?v=glance&s=books&n=507846
>
> Yes, that is the book in question. I do not know how you expect it
> to be watered down. It has an excellent inventory of available
> physical structures describing their impact on performance and takes
> a principled approach to performance tuning.

No doubt his gripe is that by not slavishly cleaving to one particular version of one particular vendor's database, the book cannot provide "cookbook" answers that work with that DB version and no other.

I was quite favorably impressed by the book; the principles it suggests are ones likely to survive version upgrades, whereas those that learned the "20 rules of Oracle 5 optimization" had to restart their education when Oracle discovered the wonders of cost-based optimization.

-- 
select 'cbbrowne' || '@' || 'acm.org';
http://www3.sympatico.ca/cbbrowne/
Signs of a  Klingon Programmer -  17. "Klingon multitasking systems do
not  support "time-sharing". When a Klingon  program  wants to run, it
challenges the scheduler in hand-to-hand combat and owns the machine."