Compress Indexes

Question

Hello, is it correct to say if I compress a Table as example:

ALTER TABLE [dbo].[Table_Items] REBUILD WITH (DATA_COMPRESSION=PAGE);

Afterwards I don't need to run compress script for it's Clustered Index since the Clustered Index is the table?

If yes, can anyone provide script to compress all Nonclustered Indexes within a SQL 2016 user DB (excluding Clustered Indexes if above is correct)?

Thanks in advance.

Answer 1

Afterwards I don't need to run compress script for it's Clustered Index since the Clustered Index is the table?

Yes.

If yes, can anyone provide script to compress all Nonclustered Indexes within a SQL 2016 user DB (excluding Clustered Indexes if above is correct)?

To compress all indexes on a table do:

ALTER INDEX ALL ON tbl REBUILD WITH (DATA_COMPRESSION = PAGE)

Answer 2

Thanks Erland for confirming.