This may be a failrly simple question. But can someone please tell me the criteria based on which we decide the values in a column fit to be included in multivalue compression. Is there some formula or it it done based on the total values / Total rows ?
Any information in this regard will be useful.
You find all details on MVC in the Database Design manual, e.g.:
Thanks dnoeth. The link is really helpful in understanding MVC.
But can you also help me to understand the values which needs to be selected.
For eg :
I have a table with total count of 1.2 billion and have 67 columns. So for me the criteria would be or exaample -
1. Select values with higher repeating values starting from 1st column.
2. Calculate the percentage by evaluation the total row count.
3. Evaluate the candidate having atlease 1% of the total row count ?
This is my evaluation but I could be wrong.
Is there a different process altogether or am I missing something here or some formula ?
Compression will also result in quicker access, but mainly because the table is smaller and thus scanned faster, e.g. 30% less space results in 30% faster Full Table Scans.
But partitioning might provider n times faster access, scanning only 1 partition out of 100 is 100 times faster when they are equally sized.