Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Server Row based compression RE: SQL Server Row based compression
JeremyE
SSCoach
Points: 16121
More actions
November 10, 2010 at 11:50 pm
#1249265
If you compress a table the data written to that table will be compressed also but compressed indexes, clustered or non-clustered, require the same maintenance as uncompressed indexes. ie; you need to defrag/rebuild them from time to time