Articles & Content

Archives

E19 - GENERATE_UNIQUE() as a range partitioning key for historical fact tables

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2015



GENERATE_UNIQUE() is underestimated as an ideal candidate for historical fact tables range partitioning key.
Presentation discusses table maintenance and query performance requirements conflict resolved by timestamp based binary unique IDs used as primary and partitioning keys.
The work covers Data Partition Elimination query optimizer behavior, time range scans and partition attachment/detachment complications.



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.