Advanced Design Considerations

Date: 
Wednesday, 7 October, 2020 - 10:00 - 11:00
Program: 
z/OS Track
Speaker: 
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
 

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