Your post is not very clear. However, I like to point out that you should not create all missing indexes that are reported. This will result in that you have too many indexes. See the missing-indexes report as a recommendation or rather a tip. You should make a judicious choice of whether you should actually implement that index.
Index created from Missing Index reappears
In SQL 2016, created Indexes from Missing Indexes.
To defragment Index Rebuild with Online and Executed missing index on Next day. Same index reappears as missing Index Report. It gets disappeared from missing index report after I rebuild only the specific index manually. This happens for multiple Indexes in the database.
CREATE INDEX missing_index_65398_65397 ON [SCHEMA_Name].[TABLE_NAME] ([COLUMN_NAME], [COLUMN_NAME]) INCLUDE ([COLUMN])
2 answers
Sort by: Most helpful
-
-
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2020-12-01T08:20:37.597+00:00 Hi @Ravi ,
From your description, it seems you rebuilt missing index according to missing index report. What is your issue? You meet error during rebuilt index? If I misunderstood, please let me know.
Suggest you read the blog Don't just blindly create those "missing" indexes!
Best regards,
Cathy