Choosing the Right Indexes

Tuesday, 24 June, 2008 - 16:15 - 17:00
Zeljen Stanic



Full Abstract:
Creating indexes on DB2 tables is one of the simplest ways to enhance performance.
It is also one of the easiest things to do - you just type CREATE INDEX right?
The skill is in knowing WHICH indexes to create - after all, too many indexes can degrade application performance.
Unicenter Index Expert from CA makes it easy to determine WHICH indexes are RIGHT for your table.
By taking into account statement execution frequency, a set of indexes that are optimized for your workload are recommended.
Index Expert will determine the ideal set of indexes for any given DB2 table
A number of events could trigger a need to consider or reconsider the current indexing strategy
The development or purchase of a new application
The discovery of a performance issue (such as might be highlighted by CA Plan Analyzer, CA Detector or CA Insight for DB2)
A need for a ‘health check’ of an existing application to ensure that the assumptions made during the database design are still valid 



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2020

Ljubljana - 8th & 9th April 2020
Belgrade - 10th April 2020
Šibenik - 14th - 18th June 2020
Zagreb - 25th September 2020
Opatija - 26th & 27th November 2020