Re: Dan Tow "SQL Tuning" and Visual SQL Tuning

Dan Tow's book and methodology are excellent. I would also recommend Kevin Meade's book "Oracle SQL Performance Tuning and Optimization: It's all about the Cardinalities" which is based on the work of Dan Tow.

On Tue, Nov 27, 2018 at 12:47 AM l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch> wrote:

> Hi Kyle,
>
> i am using Dan Tows method in principle. It is interessing that it is
> somewhat mathematical founded.
> It resembles the gradient descent approach
> https://en.wikipedia.org/wiki/Gradient_descent .
> The approach is too timeconsuming for the tuning speed I Need.
> You can approximate the filer quality using the throw away technique. This
> give sufficiently quick results.
>
> Regards
>
> Lothar
>
> ----Ursprüngliche Nachricht----
> Von : kylelf_at_gmail.com
> Datum : 26/11/2018 - 20:23 (UTC)
> An : Oracle-L_at_freelists.org
> Betreff : Dan Tow "SQL Tuning" and Visual SQL Tuning
>
>
> Does anyone follow Dan Tow's methods from "SQL Tuning" and/or use Visual
> SQL Tuning in DB Optimizer?
> Dan's method is super insightful but it's a lot of work That's why I had
> the DB Optimizer group at Embarcadero invest so much time into automating
> Dan's method with "Visual SQL Tuning" so it would do much of the hard work
> for the user.
> If any one is interested, it looks like the black Friday sale on DB
> Optimizer for 50% off is still available today:
>
> DB Optimizer for Oracle available today (black Friday) at 50% off for $357
> with discount code QUACKFRIDAY50 https://www.idera.com/buynow/onlinestore
>
> I just bought myself to have a copy just in case I need it. Not doing much
> SQL tuning these days, but it's cool to have when needed.
> VST is the unique feature to DB Optimizer bit it also does it's own ASH
> sampling and works optionally on SQL Server, Sybase and DB2
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l