September 29, 2014 at 1:18 am
Hi There,
I'm dealing with huge database. So I thought to go with the data compression because it will reduce the I/O so that I would be benefited in select queries. But I'm not so sure about the DML operations on those tables.
1. Any body help me to understand what will happen while I perform INSERT,UPDATE OR DELETE? will it affect the performance?
2. what are the performance factors to be considered in data compression?
Thanks In Advance
September 29, 2014 at 1:23 am
To enable compression on a table or index, it needs to be rebuild.
This can be done with ALTER TABLE or ALTER INDEX.
More info:
Enable Compression on a Table or Index
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 29, 2014 at 1:29 am
Koen Verbeeck (9/29/2014)
To enable compression on a table or index, it needs to be rebuild.This can be done with ALTER TABLE or ALTER INDEX.
More info:
what will happen while I perform INSERT,UPDATE OR DELETE? will it affect the performance?
September 29, 2014 at 1:33 am
You can find some answers here:
If you have Enterprise edition, you can do an online rebuild. There might still be some locking though.
If you don't have Enterprise edition, the table will be locked during the compression.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply