I am going through cleaning up one of our databases, and after deleting an unused index and adding a primary key to the ARPayments
table, sp_BlitzIndex
is now reporting an index dbo.ARPayment.Unknown (0)
. I have refreshed my indexes and there is definitely no sign of any such index.
Here is the message it shows in the output from running sp_BlitzIndex 'db_name', @Mode=4
:
Should this table be a heap? dbo.ARPayment.Unknown (0)