Examining and Generating JD Edwards EnterpriseOne Indexes

One thought on “Examining and Generating JD Edwards EnterpriseOne Indexes”

1. This was extremely useful in outlining some of the simple steps in checking indexes within JDE–Thank you for this!
   However, in our environment, we use an AS/400 to house all of our databases. Due to the differences between it and the Oracle DB environment, I had to modify the SQL statement a bit for it to work with our environment. Here is the statement I created to query all tables with missing indexes in our test (DV) environment:

   select trim(tpobnm) || ‘_’ || tpinid as jdeindex
   from CODV920.f98712
   where tpuniq 1
   and not exists
   (select 1 from qsys2.sysindexes
   where index_schema=’SBDTA’
   and trim(tpobnm) || ‘_’ || tpinid = index_name)
   and exists
   (select 1
   from qsys2.systables
   where table_schema = ‘SBDTA’
   and table_name = trim(tpobnm))
   order by 1 desc;

   Hopefully someone finds this useful somewhere, or it proves to be a good basis for other queries.

   Love the site! Lots of useful info here.
   -TB

   Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.