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
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?
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