Gather Stats and “Program - Optimizer [RGOPTM]”


Interview questions

Gather Stats & “Program - Optimizer [RGOPTM]”

<<Previous   Next>>
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.

<< Previous   Next>>
Difference between the qualifiers segment and flexfield qualifier

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..................

How can we define global segment qualifier?

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................ 

Write your comment - Share Knowledge and Experience


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring