Choosing the Right Indexes

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

Objectives:

Outline:

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 

 

sqladria

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

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023