Sql
SQL Tuning
Format: Paperback
Author: Dan Tow
ReleaseDate: 01 December, 2003
Publisher: O'Reilly Media
Rating:
The first real SQL Tuning method. 
There are many approaches out there, but they all fall into the Guess & Grimacing or Checklist categories. I have worked with Oracle databases and SQL tuning since 1987, and the reason I recommend Dan's book so highly to anyone working with SQL is that his method is the first real method I've seen in this field. Dan's is a REAL method, and it works for all SQL-based databases. It's so far the only SQL tuning book I can recommend. Any DBA, developer and troubleshooter working with database-centric systems should know this stuff.
Mogens.
excellect condition
. like new as described,fast shipment.
A Real Job Saver
In utter frustration, I was putting an index here and dropping an index there, inserting a hint here and then setting a parameter there. I was entangled in the web of horrible response time queries, not knowing what to do (except the darn hit ratios were maximum).
Within 1 day of reading Mr. Dan Tow book, I was able to bring my biggest thorn query from 8 hours response time to just 10 minutes. Boy was I blissful. Certainly Dan Diagrams rock.
|
