Assume that you have a server that is running SQL Server 2016. When you run the sys.dm_db_column_store_row_group_physical_stats query to search columnstore indexes in the current database, the query may take a long time to return the results.
This issue occurs because the sys.dm_db_column_store_row_group_physical_stats query does a join with the sys.column_store_segments view, which is expensive. After you install this update, this view is replaced with the syscscolsegments view to retrieve the needed information.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3210747 - Last Review: 2017 urt. 17 - Revision: 8
Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core