Gather Stats and “Program - Optimizer [RGOPTM]”


Interview questions
Oracle interview Oracle architecture Oracle FAQs Download Oracle/Java FAQ Test Oracle skills New More Oracle FAQs Oracle processes Oracle memory area Oracle file types Oracle database objects Oracle operators Oracle composite Oracle constraints Oracle data types Oracle DCL and TCL Oracle DML commands Oracle error handling Oracle functions Oracle procedure, package Oracle import and export Oracle sub queries Oracle table Oracle triggers Oracle views Oracle synonym Oracle indexes Oracle joins Oracle cursors Oracle form Oracle security Oracle system privilege Oracle object privileges Oracle table privileges Oracle view privileges Oracle backup & recovery Oracle DBA Oracle PL/SQL Oracle nested table & varrays Oracle large objects Oracle replication Oracle transaction Oracle optimizer Oracle auditing Oracle backup Oracle database tuning Oracle application tuning Oracle procedures Oracle functions Oracle loops Oracle exceptions Oracle Select into clause Oracle string functions Oracle numeric functions Oracle date functions Oracle translate and decode Oracle correlated sub-queries Oracle union, intersect, minus Oracle clusters Oracle sequences Oracle tablespaces Oracle object datatypes Oracle Tutorial

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
© Copyright 2016. All Rights Reserved. Terms of use \| Follow us on Facebook!