«

29 Oct

SQL Compression

Posted October 29, 2010 by algoguru in Uncategorized.

  • Compress only large tables.
  • Row compression are better than Page compression for the tables which has high DML operation.
  • When you have multiple indexes on a table, try to compress the rarely used indexes.
  • You can compress only the partitioned data.

Leave a comment