Advanced Design Considerations

Wednesday, 7 October, 2020 - 10:00 - 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 consideration 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 hopefully 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 2021

VIRTUAL EVENT - 27th - 28th May 2021