Re: SQL Tuning
Date: Tue, 01 Jul 2003 00:47:18 GMT
Message-ID: <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.
Received on Tue Jul 01 2003 - 02:47:18 CEST