Azure SQL Hyperscale auto index creation – too many
When we have the auto tuning set to ON for index creation, the Azure SQL Hyperscale db has created about 10 indexes for some of our large tables. In analyzing the indexes, some of them differ only in the ‘included’ columns while the index columns were same. This index proliferation will hurt the INSERT, UPDATE operations on such tables. Is there an option in Azure to combine/optimize indexes, rather than us manually dropping and re-creating better indexes for many tables? As of now, turning off the auto index creation seems the only thing to do. Are there other suggestions ?
Read more here: Source link
