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

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 Received on Tue Nov 27 2018 - 08:45:54 CET