Heavily using the CCI's for ss2014 DWH use case. CCIs are yielding amazing performance however still endeavouring to tune up workloads and trying to understand the no index, no stats concept with CCIs.
Information on whether you can UPDATE STATs for CCIs is mixed. Does any know if a method exists to UPDATE STATs for CCIs? Or does the Auto update Stats cover this? Believe dbcc show_statistics does not show information validating whether STAT has been updated or not.
Thanks in advance