I am creating a series of new tables that will have page level compression enabled.
Will this affect the indexes as well, or will I have to also specify compression when creating the indexes?
create table Message
(
pk_Message int identity NOT NULL constraint PK_Message primary key,
[Message] varchar(900) NOT NULL constraint UK_Message__Message unique,
DateCreated datetime NOT NULL default getdate()
) with (data_compression = page)
go
AS you can see in my example, I plan on creating a unique constraint on a rather large data type, and want to take advantage of compression.