Top 10 SQL Compare Tips. Watch now.

Azure DB - Ignore Automatic Tuning Indexes

We would like the ability to ignore indexes that Azure DB creates as part of Automatic Tuning.  Our customers have the ability to create custom reports against our DB and sometimes Azure suggests an index we don't ship that is specific to the customer. When we come across one that we thing will help we apply it, but we don't want to add that index to the base product (in most cases).  

The problem is next time we upgrade their instance we wipe out the index via SQL Change Automation and Octopus Deploy.  An example index name is below.  We name all of our indexes IX_% or UX_% so even a filter that we could specify would help.  

nci_wi_OrderReleases_6457001BFC842C960F78B76AAF900533


Answers

Sign In or Register to comment.