Skip to Content
Former Member
Aug 05, 2005 at 12:08 PM

High Cardinality Flag


If a Dimension only has the High Cardinality flag checked, I understand that the index will be B-Tree. However, if I am to determine whether this setting is correct if I want to check the cardinality i.e.

Number of Distinct Values/Number of Records

This is to be done using the Number of Records in the Dimension table and not the Fact table is that correct? Thanks