General Ledger - EBS (MOSC)

MOSC Banner

Thoughts/experience reordering gl_code_combinations raw data to improve clustering factor and perfor

in General Ledger - EBS (MOSC) Question

Hi,

I'm curious on if anyone has any experience/thoughts they would be interested in sharing, on reordering the raw data in gl_code_combinations to align with the ordering approach of building the gl_code_combinations_cat index.  The goal would be to improve performance whenever the gl_code_combinations_cat (a recommended concatenated index) is used. 

For background, the gl_code_combinations_cat index (described in MOS Note 858725.1) is a concatenated index recommended by Oracle development that is built with the most selective segment# columns in descending order.  Per 858725.1, an example is:

Consider that gl_code_combinations has the following number of distinct values, per segment:

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

EBS GL Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center