Damir Vadas

Custom Bind Values in SQL Optimizer

Introduction In SQL Optimizer version 9, a very helpful feature was introduced:“Test Run Different Bind Values”. This new feature allows user to define more than one binds set that can be used in testing of possible candidates for better...
518 3 /
Richard To

How to speed up multiple aggregation functions apply to the same table

If you want to find the minimum salary among all employees, you may issue a SQL statement like this: select min (emp_salary) from employee Plan 3 SELECT STATEMENT 2 SORT AGGREGATE ...
1615 5 /
Richard To

Bind Sensitive SQL May Also be Place Sensitive

I have heard a lot of people ask "Why my SQL performance is vary depending on where the SQL is executed ?", sometimes you may notice that the same SQL is performing good in one place, but not good in another place. If your SQL has bind variables...
1417 0 /
Richard To

Real Workload Based Index Advisor Works on a Complex Environment - Toad Xpert SQL Optimizer

Here is a case study that I would like to share with our users: http://software.dell.com/documents/haas-group-international-chemical-company-optimizes-database-preformance-case-study-72081.pdf " This enterprise data system is part of what makes...
1002 0 /
Richard To

SQL Rewrite to Twist Cost Estimation

There are mainly three problems that database SQL optimizer cannot find the best way to process your SQL statements. Cost estimation error The cost estimation error is not only caused outdated statistics, but lots of other factors that a SQL's...
1297 0 /