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

twurm September 29, 2020 22:08

Comments

1 comment

Hi @twurm

We do have the option to "Ignore Indexes", however, this will ignore all indexes within the database.

https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-project-options#Settingprojectoptions-Ignoreindexes

Unfortunately, we don't have a way to filter indexes individually as they're a part of the table, and using the above option would essentially be an "all or nothing" option.

If you wish for indexes to be filtered, then I'd suggest making a post on the UserVoice here which is used to plan new features: https://redgate.uservoice.com/forums/141379-sql-compare

DanC October 01, 2020 16:04

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Azure DB - Ignore Automatic Tuning Indexes

Comments

Add comment