Columnstore index are not rebuilding about azuresql HOT 4 OPEN

Is there a reason why you didn't do a rebuild WITH (ONLINE = ON); For 2019 it then does an online rebuild.

from azuresql.

@yochananrachamim it looks like in the section with the comment Remove statistics if it is handled by index rebuild / reorginize the script removes stats that exist in #idxBefore but that includes all indexes, not just the ones that are being rebuilt. Should it include the same where clause and/or delete records from #idxBefore that aren't being updated?

where
    (
        page_count> @minPageCountForIndex and /* not small tables */
        avg_fragmentation_in_percent>=5
    )
  or
    (
        @mode ='dummy'
    )

from azuresql.

@Nimrodsv - yes, at the moment this script is not being designed to handle columnstore indexes.
@dandenton - you are absolutely right. can you please open another issue so I can fix it in the next cycle of development for this maintenance script.

Thank you.

from azuresql.

for column store indexes you may use dummy mode at the moment - it will process them with reorganize.

from azuresql.