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