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