Multi value compression

Database

Multi value compression

Hi all,

I want to use multi value compression in our existing DWH.
Is there any way through which we can compress existing data all in once in different table.
I am thinking about writing a macro which will run and find datavalue with maximam feequency and then compress that data values for a particular column.

Please advice.

Regards,
gander_ss