I was experiencing terrible performance after restoring a .BACPAC to Azure. I finally checked my indexes in sys.indexes and they all have is_disabled = 1. My coworker restored the same .BACPAC and did not have this issue. I have a couple questions:
- What could have caused this?
- Is it safe to simply enable them? Or might they be disabled for a reason (like being disabled while being rebuilt)?
The only schema changes I made to the db since restoring it were adding a column to an unrelated table and adding a new index to a table which previously did not have an index (this index is the only one still enabled). Thanks!