Re: good sources for tuning info

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:hjrua.31004$1s1.456212_at_newsfeeds.bigpond.com...
>
> "Ryan" <rgaffuri_at_cox.net> wrote in message
> news:2pjua.38320$g41.3339796_at_news1.east.cox.net...
> >
> > "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
> > news:3EB9BDE9.3CB5_at_yahoo.com...
> > > Greg Teets wrote:
> > > >
> > > > On Wed, 07 May 2003 21:39:27 GMT, "Ryan" <rgaffuri_at_cox.net> wrote:
> > > >
> > > > >I have Performance Tuning 101 and Guy Harrisons High Performance
> > Tuning. I
> > > > >read the Niemic book which I know is unpopular.
> > > > >
> > > >
> > > > Why is it unpolular? I thought it was pretty good.
> > > >
> > > > Thanks.
> > >
> > > Many will people will disagree - but it IS a very good book. I have
> > > used it on more than one occasion to save my skin, for example:
> > >
> > > a) standing on it to reach an item on a high shelf
> > > b) getting a BBQ fire started
> > > c) an alternative for the dog chewing my socks
> > > d) stopping the car from rolling down a hill
> > >
> > > Make no mistake, there are plenty of uses
> > >
> > > :-)
> > >
> > >
> > > --
> > > =========================
> > > Connor McDonald
> > > http://www.oracledba.co.uk
> > >
> > > "Some days you're the pigeon, some days you're the statue"
> >
> > Conner,
> >
> > do you know any other good sources for SQL tuning? The books seem to
> provide
> > the basics, but there are lots of possible cases. Trial and error is
very
> > time consuming. How is the Burleson Tuning book? Any good sites other
than
> > the ones I listed? Ive been to your site.
>
> You could search the google archive for the end of March/beginning of
April
> for references to Burleson. You'll see he posted a tuning script from his
> book as an answer to someone's question. Only problem, it didn't do what
he
> said it would do, except if you're using the most utterly basic data
> structures.
>
> And that's typical of the quality of his work. It's glib, simplistic,
> misleading, techinically inaccurate, and not properly researched.
>
> Steer well clear.
>
> Indeed, steer well clear of basically anything published by Oracle Press.
> They don't vet their stuff very carefully before it hits the street (which
> is why their 10i book will probably be on the shelves two hours after 10i
> Release 1 is released).
>
> Thomas Kyte is authorative. Guy's book is practically definitive (as is
> Thomas Kyte's Expert One on One). But the plain fact is that there are
very,
> very few good tuning books out there, largely because the market has been
> cornered by the "well-known" authors. If you're busy actually researching
> the subject, it's hard to find time to write about it. Those who write
about
> it *tend* to be those who don't research it. Kyte, Lewis and Harrison are
> glorious exceptions to the rule.
>
> Regards
> HJR
>
>
>
>

Howard,

you got your feet wet with the chapter in Beginning Programming... maybe you should write one. A guy I used to work with said the best query tuner he ever worked with wrote a comprehensive book in Korean. Can anyone translate it to english... Im getting desperate.

There is so much more to query tuning than is in the books. It would really help the literature if someone would sit down and look at where Harrison leaves off and go from there. Lots of examples and cases... Received on Thu May 08 2003 - 15:49:04 CDT