I have a question regarding an issue I am having.

I have a table that has 2 indexes – a clustered index and one non-clustered index.

• The clustered index key column is of type INT
• The non-clustered is on a varchar(80) column

After I insert rows to the table, when I check the index stats, I see that the non-clustered index is bigger than the clustered index in terms of size.

When I do an index rebuild, it gets smaller.

Then when I add more rows, it gets bigger again. Why is that?

Note that it’s a new table with 0 deletes, is it fragmentation? Is it because of the index key types?

I set fill factor to 0 to reduce fragmentation