Home Forums SQL Server 2016 SQL Server 2016 - Administration Columnstore Indexes - do we need to perform any maintenance on them? RE: Columnstore Indexes - do we need to perform any maintenance on them?

  • February 8, 2019 at 11:53 am

    #2021535

    Jeff Moden - Friday, February 8, 2019 9:36 AM

    Is there a measurement that can be taken on such things to determine when rebuilding columnstore indexes would actually benefit from a rebuild?

    Yes. Here's an article introducing it.

    The goal is to have an even distribution of rows across the total_rows.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning