Topic: Cross Platform DB2 for z/OS & LUW
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.