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

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>

On Tue, Nov 27, 2018 at 12:54 AM kyle Hailey <kylelf_at_gmail.com> wrote:

>
> 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