My Oracle Support Banner

E1: TDA: Steps to Create a New Index on an EnterpriseOne Table (Doc ID 634520.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.
Check for relevance Mar-23-2016



Purpose

This document provides the steps to create a new index on an EnterpriseOne table in Object Management Workbench (OMW) as well as troubleshooting steps when encountering an issue with an index.

NOTE: Creating a custom index can have an adverse effect on performance.  It is the responsibility of the customer to test and validate any newly created indices and determine if the index should be deployed within the EnterpriseOne environment.
If any issues are encountered in standard applications using tables with modified or custom indices,  you should test the application using unmodified /pristine table (without any custom or modified index )before contacting Oracle Support. 

Scope

 This document is intended for the EnterpriseOne developer or system administrator who is reviewing or creating indices on an EnterpriseOne table.

Details

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
Purpose
Scope
Details
 Creating an Index
 Adding an Index to a Bootstrap Table
 Database Replication
 Troubleshooting Index Errors
References

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