• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Is it possible to specify index number?

Andrew2009

Well Known Member
I'm adding a new index to F0911 and the new index uses the next sequential number (F0911_38). Is it possible to specify an index number when you create an index (ie. F0911.50)?

Thanks
 

BOster

Legendary Poster
I think I saw someone post on here that a good practice when adding a custom index to a pristine table is to add, and then delete, a bunch of indexes first then add the custom index. I think that is effectively the only way to specify the index number. This will help prevent possible problems when taking an ESU or doing an upgrade where Oracle may add indexes to the table. Hopefully the indexes Oracle adds will have a number below your custom index.
 

Larry_Jones

Legendary Poster
Don't worry about the Index Number.
1. Define your new index in JDE but DON'T Generate the Index.
2. At the Database level create a new index (named whatever) matching the logical index you defined in JDE.

That's all you need to do for SQL Server or Oracle DBs.

Come to think of it unless you're needing to reference the index in JDE code (ER or C) you don't even need to do Step 1.
 

johndanter

Legendary Poster
Just get your DBA to rename the index you create.

All ours here start with RRD to make sure they are clearly custom
 
Top