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.