In SQL Optimizer for SQL Server we have built a very useful test run wizard (see my blog post Test Running a Tuned SQL is Not An Easy Job”) to help users select the best SQL alternatives for their spe...
A junior developer came to me recently and asked me a SQL transformation question. He gave me an example of a SQL statement similar to this one: select * from TableA A where A.KeyCol/10 = 12345 The p...
This blog is the finale in this series about common misconceptions surrounding SQL tuning. I selected this topic as my last one because it is a very common misconception in a DBA or developers mind. I...
Scan SQL helps you identify problematic SQL statements in your database environment by automatically extracting statements embedded in database objects, stored in application source code and binary fi...
This tip gives an overview on the functionality in the Batch Optimizer. Batch Optimizer Process The Batch Optimizer combines into one simple process the finding of SQL statements in your applicatio...
When you are executing SQL statements to find which one is the best, you need to take into consideration the factors that can skew the accuracy of the test results. These factors include caching the d...
When you are executing SQL statements to find which one is the best, you need to take into consideration the factors that can skew the accuracy of the results of the testing. These factors include cac...
This tip covers how to consider the disk I/O when selecting the best SQL alternative. When selecting the best performing SQL statement for your application, how should disk I/O be weighed in compariso...
This tips covers the options for terminating the SQL alternatives when they are executed in the Batch Run in the Optimize SQL module. The SQL optimization process in the Optimize SQL module generates ...
This tip explains the order in which the alternative SQL statements are displayed in the Tuning Lab. After the optimization process is finished, the SQL alternatives are displayed in the order of the...
When you are executing SQL statements to find which one is the best, you need to take into consideration the factors that can skew the accuracy of the results of the testing. These factors include cac...
This tips covers optimizing SQL statements that use a VIEW in place of a TABLE. In early versions of the Oracle database, a VIEW was handled like a temporary table that stores the temporary data from...
