I am using SCD to create a data warehouse and I am attempting to optimize the creation of thje dimensional data by looking into index creation on the destination table. Since SCD only allows a single Business Key designation, I would assume that I should
index that column however after thinking about it I cant see how (after several dimensions are created) that an index on the business key alone would suffice. Would nt an index be appropriate on the business key as well as the primary-record column?
View Complete Post