InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Difference Between Running Gather Stats And "program - Optimizer [rgoptm]" In Oracle General Ledger? |
|
Answer» “Gather Stats” will simply gather the stats against existing TABLES, indexes ETC. However Gather Stats does not create any new indexes. But “PROGRAM – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided ACCOUNTING segment has the indexed flag ENABLED. “Gather Stats” will simply gather the stats against existing tables, indexes etc. However Gather Stats does not create any new indexes. But “Program – Optimizer[RGOPTM]” can create indexes on GL_CODE_COMBINATIONS, provided accounting segment has the indexed flag enabled. |
|