Index maintenance in Azure Synapse

Quick question regarding index maintenance best practices for azure synapse dedicated sql pools.

With specific regard to clustered columnstore indexes (as they are the default construct for tables in synapse) do the same monitoring and maintenance rules apply as in sql server? Are there any useful purpose-built tools or custom processes for reorganizing/rebuilding CCIs on larger tables or are maintenance windows still a requirement for slow data change dimension tables, for example?

Synapse documentation is still a little sparse on some best practices.

Thanks in advance

submitted by /u/ATastefulCrossJoin
[link] [comments]

Read more here: https://www.reddit.com/r/AZURE/comments/lr1jq6/index_maintenance_in_azure_synapse/

Content Attribution

This content was originally published by /u/ATastefulCrossJoin at Microsoft Azure, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: