Skip to main content
SUBMITTED

Change types of SCD Is Current and SCD Is Tombstone to smaller types

  • February 27, 2020
  • 0 replies
  • 15 views

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8

Currently the fields added by history functionality to indicate status are of type bigint. While this may have less of an impact for relatively small dimensions, it will add up for larger tables. Using a bit would mean one byte per record and fit with the boolean nature of the field, using a bigint for both takes 16 bytes per record.