Sizing the FCST_ITEM table overview

The FCST_ITEM table is the most important table to consider for sizing, so the following calculations focus on the FCST_ITEM table's row count. As a general database administrator best practice, you should monitor all tablespaces, but sizing the data and index tablespaces for the FCST_ITEM table is especially critical because that is where the vast majority of the data for the Labor Budgeting modules is stored.

The base amount for one copy of any budget or forecast is the first critical piece of information. Using a sample hierarchy consisting of five location types (Corporate, Division, Region, District and Store), the base amount for one copy of any budget or forecast is calculated as follows: