Forum Discussion
Reduce Cardinality on an Index
Are there any tricks to reduce cardinality on an index? I have a table thats 8m rows, and the index is 9% of the entire model. I need the index to link to two copies of the table, as I need to m...
Anonymous
Is your index an integer value? Those are smaller to store if you can have the engine store using value encoding.
Also, disable the 'Available in MDX' property of the column so the model does not build the hierarchy. You can disable this using Tabular Editor from SQLBI.
https://www.sqlbi.com/tools/tabular-editor/
Anonymous
Is your index an integer value? Those are smaller to store if you can have the engine store using value encoding.
Also, disable the 'Available in MDX' property of the column so the model does not build the hierarchy. You can disable this using Tabular Editor from SQLBI.
https://www.sqlbi.com/tools/tabular-editor/