Database Maintenance

The Advanced Store 6.8 system maintains several databases. The following databases have the highest level of activity and data volume.

  • NCRWO_EJ
  • NCRWO_Transactions
  • TransactionLogDb

Since these databases are regularly queried, it is crucial that database administrators have a database maintenance plan in place to ensure that transaction data retrieval is efficient.

Note

Implementation of the outlined recommendations depend on each retailer’s usage.

Before fixing database indexes, retailers must first identify where wait time is an issue. For more information, consult with your database administrator.

The following sections discuss the generic database maintenance and tuning recommendations.