If I set compression (either page or row) on the clustered index of a table, is that the same as setting compression on the table?
SQL Server provides options for doing both, which suggests that they are different, but I was under the impression that a clustered index and a table were essentially the same thing, and my mental model of how clustered indexes work tells me that compressing the clustered index must also compress the table.