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 9:36 am

    #2021522

    Grant Fritchey - Friday, February 8, 2019 6:47 AM

    You are going to want to rebuild columnstore indexes on some sort of basis. This does two things. It helps to condense the columns down so that the compression works best. Also, it gets rid of all the data in the delta stores, again, improving compression and overall performance. Also, keep the statistics up to date.

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

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)