What Developers must know about DB2 for z/OS indexes

Date: 
Wednesday, 28 svibanj, 2014 - 09:15 - 10:00
Program: 
z/OS Track
Speaker: 
Cristian Molaro
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.
 

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