Hello All,

Can you please help me with below doubts.

1. In a table data is inserted in daily (around 7 to 12
Million rows)
2. In the mean time data is selected from this table.
3. And every 2 days it gets truncated.
4. This table has only non-clustered index.

My questions:

1. What will happen to statistics on this table, will it get
updated when the table is truncated and new data is inserted
2. If stats doesn't get updated, will it get updated if the
table has a clustered index or if the data is bcp'ed in
instead of insert?
3. Will there be any fragmentation? If yes, how can we fix