Legacy platform

Database checklist

You can review the database checklist for specific recommendations.

Table 1. Database checklist
Recommendation Section Dev Prod Comments
Monitor and adjust indexes Sterling Order Management System Software schema C C The Sterling Order Management System Software schema comes with a default set of indexes for general use. In some cases, the indexes may not apply to your operational environment.

Regularly monitor the resource cost of frequently used queries. See if additional indexes are needed. Also monitor if indexes can be deleted.