Articles & Content


Advanced SQL Design Considerations

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015

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

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.