• My Bad, I was thinking Non-Clustered and Typing Clustered.

    Jeremy was right.

    and maintaining indexes does not change, what you would do for non-compressed you would do for compressed.

    Here are the list of compression cross applications straight from the camel's mouth. http://msdn.microsoft.com/en-us/library/cc280449.aspx

    A whole table that is stored as a heap.

    A whole table that is stored as a clustered index.

    A whole nonclustered index.

    A whole indexed view.

    For partitioned tables and indexes, the compression option can be configured for each partition, and the various partitions of an object do not have to have the same compression setting.