Forum Discussion
DBCC SHOW CONTIG returns 0 records in SQL Server 2014 but 2 records in SQL Server 2016
I have a table with records that has Column Store Index. When I run the following in the SQL Server 2014 Version I get no rows. DBCC SHOWCONTIG ('dbo.myTable') WITH TABLERESULTS, ALL_INDEXES, NO_INF...
Kanishka_Basak I know I'm not directly answering your question, but do you know the concepts of fragmentation DBCC SHOWCONTIG deals with don't apply do columnstore indexes?
Do you know columnstore indexes have completely different problems related to row groups and the maintenance needs to check sys.column_store_row_groups and dm_db_column_store_row_group_physical_stats ?
DennesTorres I am not aware of that, but looks to me that what you mention may be playing a part here? is that correct?
Kanishka_Basak IMHO, more than that. You shouldn't be concerned about SHOWCONTIG at all. For columnstore indexes, the structure is different, the maintenance is different as well. I don't have a link now, but It's not difficult to find more about them and you will need the two DMV's I mentioned.
DennesTorres Thank you,I will look through those DMVs, however, if you come across some more info/link on this do share them.