yochananrachamim / AzureSQL

129 stars 61 forks source link

On index rebuilds, ignore TVFs that return a table with an index defined #24

Closed Mitch-Wheat closed 1 year ago

BP-vismaNmbrs commented 2 years ago

Very specific case, but a good catch.

yochananrachamim commented 1 year ago

The added code ignores the parameter @indexStatsMode I've added the implementation as you suggested to avoid maintaining indexes when they are from table value function. Thank you for suggesting that.