To improve database access performance
Reindex GreeneStep OnCloud Database using SQL Server Command
If you are not able to retrieve the records from the documents or for other purpose in the Greenestep product, there may be a index problem( The data cannot be retrieved with its index).
In that case,
For Re-indexing the Database run the following SQL command
GS_DATABASEREINDEX is a store procedure part of OnCloud database.
Execute the following command from Query Analyser as and when needed