I am planning to apply PAGE compression to some of the big tables in my database (a data warehouse). These tables are fairly big with over 15 Billion rows.
When I applied the compression in test environment, the whole process took around 22 hours. These tables are accessed daily with quite long running queries.
- While the compression is being applied would there be any effect on the queries that are running? Any lock etc I should be aware of?
- Is there a staggered approach to applying compression?
- Any other input/feedback you might have?