Symptoms
There was a need to re-index the K2 DB
Having issues with INDEX rebuilding
Running the following is causing issues
ALTER INDEX ALL ON [K2].[SmartBroker].[SmartObject] REBUILD
Diagnoses
The better option would be to Re Index the whole K2 Database using the K2 Stored Procedure created to do that.
Resolution
There is a stored procedure called that you can run to re index the K2 DB
Please follow these steps:
• Create Backup of the K2 DB
• Please get your DB admin to check this stored proc and run it.
• Run the following stored procedure -andgt exec Utility.Maintain_IndexDefrag