My Oracle Support Banner

E1: TDA: Removing Standard Indices on EnterpriseOne Tables (Doc ID 656520.1)

Last updated on JANUARY 03, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.93 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201048783


 



Symptoms


I would like to remove "redundant" indices for some JDE EnterpriseOne standard tables.

For example, for the table F0911, the following are some indices defined:

COMPOSITE, NONCLUSTERED, NONUNIQUE indices "F0911_18", "F0911_28", "F0911_29", "F0911_33" :

        - F0911_18 (GLAID, GLLT, GLDGJ(Descending), GLCRCD, GLSBL, GLSBLT)

        - F0911_28 (GLAID, GLR1)

        - F0911_29(GLAID, GLCTRY, GLFY, GLFQ, GLLT, GLSBL, GLSBLT, GLCRCD)

        - F0911_33 (GLAID, GLCTRY, GLFY, GLFQ, GLLT, GLSBLT, GLSBL, GLCRCD)

From the database point of view, the redundant index to "F0911_18", "F0911_28", "F0911_29", "F0911_33"    
indices, is single column, NONCLUSTERED, NONUNIQUE index  "F0911_14"
        -  F0911_14 (GLAID)

By removing the "redundant" index e.g. F0911_14 above, it would speed up database performance.

What is the recommendation regarding removing a standard index on an EnterpriseOne table?

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.