Re: SQL Tuning
Date: Tue, 1 Jul 2003 16:25:40 +1000
Message-ID: <bdr9ft$epn$1_at_otis.netspace.net.au>
[Quoted] "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.
>
[Quoted] It may be worth pointing out that Guy Harrison works for Quest these days... Received on Tue Jul 01 2003 - 08:25:40 CEST