In SQL Server 2012, I am seeing large cardinality estimate discrepancies for a columnstore index scan. It looks like statistics have been generated for the index, but I don't see any details in DBCC SHOW_STATISTICS (this may not be supported for columnstore indexes).
Can statistics be updated for a columnstore index, or are there other ways to address this large cardinality estimate discrepancy? I have not been able to find definitive documentation but noted that
UPDATE STATISTICS failed because statistics cannot be updated on a columnstore index. UPDATE STATISTICS is valid only when used with the STATS_STREAM option exists in