Re: SQL Tuning

"John" <junk_at_junk.com> wrote in message news:<bdr9ft$epn$1_at_otis.netspace.net.au>...
> "Ryan" <rgaffuri_at_cox.net> wrote in message
> news:qS4Ma.38498$pH3.13540_at_news2.east.cox.net...
> >
> > <- (-)> wrote in message news:3f006993.14631320_at_newzilla.xs4all.nl...
> > > I am looking for reviews and opinions on using software for SQL tuning
> > > oracle 9i release 2. Any URL's that compares several oracle 9i release
> > > 2 SQL tuning software programs are welcome.
> > >
> > > In case there are no such reviews.
> > >
> > > What are you're opinions about the following SQL tuning software
> > > programs:
> > >
> > > 1. Quest Central SQL tuning option for oracle.
> > >
> > > 2. Lecco DB Expert for oracle.
> > >
> > > 3. Lecco SQL Expert for oracle.
> > >
> > > 4. Embarcadero SQL Tuner for oracle.
> > >
> > > 5. CA SQL-Station.
> > >
> > > Which is the best and why?
> > >
> > > Are these programs about to be extinct because of the (I assume
> > > improved) CBO in Oracle 10i which will be finished late 2003?
> > >
> > > Thanks
> > >
> > >
> >
> > i downlaoded the free verison of embarcadero. its a piece of garbage. all
> it
> > does is try out every possible message to see if it can improve your
> query.
> >
> > completely worthless. all of its 'reports' are just generic sql scripts
> > freely available on the web that they put in a nice gui.
> >
> > I would assume that most of this SQL software is worthless also. Get Guy
> > Harrisons SQL tuning book.
> > Its cheaper than the software and more useful.
> >
>
> It may be worth pointing out that Guy Harrison works for Quest these days...

why does that matter? man cant right a good book becuase of his employer? Received on Tue Jul 01 2003 - 13:17:36 CEST