Previous	Next		Contents	Index	Navigation	Glossary	Library

You can also update statistical information about your data, such as the size of your balances and combinations tables, the number of accounts with a particular segment value, and the number of account balances associated with each accounting period. This information improves the performance of your journal entry posting and financial reporting process.

To keep these statistics current, you should run the Optimizer at least once a period, or any time you add several segment values, define a new chart of accounts, or add or delete summary templates.

Prerequisites

   Define your account segments.

   Specify whether you want to index a particular segment in your chart of accounts using the Key Flexfield Segments window.

   Define your account segment values.

   Define summary templates.

   To create and drop indexes for your chart of accounts:

1. Freeze your account structure.

1. Navigate to the Submit Request window.

2. Select the Optimizer program.

3. Enter Yes for Maintain Indexes to create or drop the indexes for your chart of accounts.

The Optimizer creates an index on a segment if one does not yet exist, and drops an index on a segment if you no longer index the segment. This is useful when you define a new chart of accounts for which you want to index particular segments or when you want to add or drop an index for an existing segment in your chart of accounts.

   To update statistical information about your data:

1. Navigate to the Submit Request window.

2. Select the Optimizer program.

3. Enter Yes for Gather Statistics. The Optimizer program gathers and updates statistical information about the size of your balances and combinations table, the number of account combinations with a particular segment value, and the number of account balances associated with each accounting period.

See Also

Defining Key Flexfields

Defining Segment Values

Defining Summary Accounts