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