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