Steve Hilker

Get index recommendations with SQL Optimizer for DB2 z/OS

Using indexes can improve the performance of applications using the database. This is a pretty well known fact. However, determining which index, or combination of indexes that will give you the best performance used to be a difficult and time consuming...
1903 0 /
Ben Boise

Interesting Developments with the SQL Optimizer for DB2 LUW

I was recently demonstrating our SQL Optimizer for DB2 LUW solution when a question came up regarding comparing Access Plans in the Index Expert portion of the Optimizer. Excellent question indeed! However, before I go any further, perhaps a little background...
1250 0 /
Ben Boise

Proactive Index Usage Analysis with Quest SQL Optimizer for DB2 LUW

Using indexes can improve the performance of applications using the database. This is well known to many, many people. However, the application of too many indexes can have the reverse effect. There’s a balance that must be struck and you may find...
1389 0 /