AzureSQLMaintenance.txt | Total number of indexes reported to the output window is wrong

yochananrachamim / AzureSQL

129 stars 61 forks source link

AzureSQLMaintenance.txt | Total number of indexes reported to the output window is wrong #1

Closed yochananrachamim closed 6 years ago

yochananrachamim commented 6 years ago

while counting the indexes there is an extra filter for index_id 1 or 2 which eliminate counting of indexes if there are more than two indexes on a table. this does not impact any functionality, and it's just reporting issue.

yochananrachamim commented 6 years ago

Resolved.