Database checklist

Table 1. Database checklist
Recommendation Section Dev Prod Comments
Monitor and adjust indexes Sterling Selling and Fulfillment Foundation schema C C The Sterling Selling and Fulfillment Foundation 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.