General Ledger - EBS (MOSC)

MOSC Banner

Program - Optimizer

edited Oct 2, 2012 11:38PM in General Ledger - EBS (MOSC) 18 commentsAnswered ✓

Hi Team,

Greetings of the day.  I just wanted to know more about the program "Program - Optimizer"  .

From MOS doc below

Program GL Optimizer: Gather Statistics = yes, what does this program do exactly? (Doc ID 751560.1)
How to Improve Journal Import Performance and Performance of Other GL Programs in 11i (Doc ID 198437.1)

Could see

Run the General Ledger Optimizer program to create or drop indexes for those segments in your chart of accounts that you have marked for indexing in the Segments Definition form. It indicates whether you want the database column in the combinations table used to store this key segment to have a single- -column index. You should create indexes on segments you expect to have many distinct values and not create for segments with just a few distinct values.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center