After you truncate a table that has a clustered columnstore index, the automatic update of statistics feature no longer runs. This may decrease SQL Server performance if data distribution changes in a way that triggers an inefficient execution plan.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
ID članka: 3210652 - posljednja izmjena: 17. sij 2017. - verzija: 4
Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core