Oracle apps - Difference
between running Gather Stats and “Program – Optimizer [RGOPTM]” in Oracle
General Ledger - June 11, 2010 at 15:30 PM by Babu Kunwar
Difference between running Gather Stats and “Program –
Optimizer [RGOPTM]” in Oracle General Ledger
Former cannot create any indexes but Stats will simply gather the stats against
existing tables. But latter can create indexes on GL_CODE_COMBINATIONS, only if
accounting segment has the indexed flag enabled.
A segment qualifier identifies a particular type of value in
a single segment of a key flexfield, and segment qualifiers can identify the
account type Planning and Defining Key Flexfields..................
A segment qualifier for all segments is known as global
segment qualifier. We can define global segment qualifier by tying the segment
qualifier to global flex field qualifier................