Recently I had a customer who contacted me with the following problem:
I have made my data base connection to the iSeries (AS400) and can see my files and library list structure.
When I go to access...
When you optimize a simple SQL statement, Quest SQL Optimizer may only generate a few SQL alternatives using the default settings in the Optimizer options. It is very likely that many more alternative...
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...