DB2 indexes are key in SQL Performance, but they can be a source of problems as well.
It is critical to understand the advantages of proper index design, and the dangers related to index over-utilization as well.
This session discusses the indexes options available for developers, how to use them, and how to get the most of index design.
We will see what is new in DB2, including indexes on expressions, include column indexes, and rebuild index avoidance.
Discussed topics also include virtual indexes, table control partitioning, and index compression.
Locking considerations when indexes are involved. Monitoring and utilization tracking in Real Time Statistics that will allow you to remove unnecessary indexes.
We will cover tips and real life example of best practices.