Advanced Design Considerations

Monday, 26 May, 2014 - 09:30 - 11:00
z/OS Track
Phil Grainger

During the design of a DB2 application, there is now a lot more to consider than just “what should the tables look like”. We need to take into onsideration where we should create indexes, and why. We might think about partitioning for performance or for manageability. What about partitioned and non partitioned indexes – they each have their advantages and disadvantages. More recently, we’ve been given the option to create Materialized Query Tables, but when would these be good to use?

This presentation steps through some of the new (and not so new) elements of DB2 database design and highlights pros and cons of each

Unfortunately, as with a lot of DB2 decisions, there are no absolute correct answers – the right answer in your case will always “depend” on circumstances, but opefully this presentation will give you the information you need to make informed choices



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

VIRTUAL EVENT - 25th - 27th November 2020