4

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

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.

0 comments

Please sign in to leave a comment.