[-]
 [+]
Products
 [+]
CRM
 [+]
Purchase
 [+]
Sales
 [+]
Retail
 [+]
Production
 [+]
Finance
 [+]
Accounting
 [+]
Ecommerce
 [+]
Warehouse
 [+]
Admin & Operations
  
  
  
  
[-]
  
  
  
  
[-]
  
Updated on 2/4/2019
How-to-do Articles
Database Re-index
Direct link to topic in this publication:

Objective/Goal:

To improve database access performance


Solution :

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


EXEC GS_DATABASEREINDEX