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@xxxxxxxxx
Datum : 26/11/2018 - 20:23 (UTC)
An : Oracle-L@xxxxxxxxxxxxx
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
