Should I not even bother compressing non-clustered indexes?
OR if I do, should I do one buy one non-clustered indexes? Or they won't get compressed?
what if my table does not have clustered indexes? it only has a composite primary key, non-clustered. And a dozen of nonclustered indexed. Should I then not consider such table for compression? Or it will still benefit from it?
Voldemar likes to play CHESS (and IS good at it!)