Skip to main content
Database Administrators

Return to Answer

improved language
Source Link
tinlyx
tinlyx
  • 3.7k
  • 14
  • 48
  • 79

anotherAnother answer to thisthe question: "Why are your indexes larger than your actual data" is : my

my table had a clustered columnstore index that compressed the table when. When I added a nonclustered index to this table with the most offof the columns, the size of nunclusternoncluster index was 10 times bigger than columnstore index table.

another answer to this question: "Why are your indexes larger than your actual data" is : my table had a clustered columnstore index that compressed the table when I added a nonclustered index to this table with the most off columns, the size of nuncluster index was 10 times bigger than columnstore index table.

Another answer to the question: "Why are your indexes larger than your actual data" is :

my table had a clustered columnstore index that compressed the table. When I added a nonclustered index to this table with most of the columns, the size of noncluster index was 10 times bigger than columnstore index table.

Source Link
nimajv
nimajv
  • 101
  • 1

another answer to this question: "Why are your indexes larger than your actual data" is : my table had a clustered columnstore index that compressed the table when I added a nonclustered index to this table with the most off columns, the size of nuncluster index was 10 times bigger than columnstore index table.