Dan Tow "SQL Tuning" and Visual SQL Tuning

[kyle Hailey]

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

[Mladen Gogala]

Hi Kyle,

I read the book. It's an excellent book, but when you actually try to
follow the tree, it's a lot of work. I prefer using the Force, which
means to rely on my understanding of the data, wait events, explain plan
and my gut feeling.  Fortunately, I am no longer a DBA, which means that
I no longer have a database to support in sickness and in health, till
my death takes us apart. In other words, I rarely do SQL tuning these
days. However, if I had to do it, I would still use the method R
proposed by Carry Millsap and based on the events and trace.  During my
not so short tenure as a DBA, I noticed that the most of the performance
problems stem from an inadequate data model. However, developers usually
hate it when you formulate it like that.  There are many war stories I
could tell, probably like many other DBA folks on this list. All things
considered the best way to tune the SQL is to have it tuned by the
others.  I call that a Wally method. It's scientifically proven to be
the best.

Regards

Post by kyle Hailey
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
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

[Harmandeep Singh]

I follow Dan Tow " Tree Diagram " approach when sql is bit longer and it
best . Nothing beats it

Otherwise tuning sql based on explain plan and run time plan with costing
information is easy.
SQL tuning is all about understanding business logic of sql and intercation
with developers and business users sometimes

Regards
Harmandeep

<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Post by kyle Hailey
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
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

[kyle Hailey]

Yes, the majority big of optimization wins comes down business logic and
schema. Often it's not possible to do that.
and yes, Dan's method is a lot of work IMO thus why I love having software
doing most of the tedious grunt work. Yeah, when I read Dan's book I
thought it was cool, but so time consuming, that I would rarely do it, but
having some software to do a lot of the tedious work makes it much more fun.
Now that I bought my own copy, I plan to start looking into Visual SQL
Tuning again and try and blog on it.
It really stuck home when I was at Embarcadero and a customer sent in 3
problem queries that Oracle mis-optimized. Using Dan's method it was easy
to see what the solutions were. One of the hardest for Oracle optimizer was
a query that had only 4 tables but the most efficient path was to join the
first two tables then join the second two tables and then join the result
set. Oracle only joins in one table at a time so this isn't a method it
would find, but using subqueries and hints one could force the optimzer to
follow that path.

Post by Harmandeep Singh
I follow Dan Tow " Tree Diagram " approach when sql is bit longer and it
best . Nothing beats it
Otherwise tuning sql based on explain plan and run time plan with costing
information is easy.
SQL tuning is all about understanding business logic of sql and
intercation with developers and business users sometimes
Regards
Harmandeep
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#m_2859371604671892423_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Post by kyle Hailey
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
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

[l***@bluewin.ch]

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 : ***@gmail.com
Datum : 26/11/2018 - 20:23 (UTC)
An : Oracle-***@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

[Brent Day]

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.

Post by Mladen Gogala
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----
Datum : 26/11/2018 - 20:23 (UTC)
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
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