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

Last updated on JANUARY 03, 2023

Applies to:

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

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