Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    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/

     

jdbuchanan71's avatar
jdbuchanan71
Super User
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

thanks for the reply! yep its an integer. i've not heard of available in MDX though, but looks promising so will try that!