Tag «indexes»

[SQL] Identify & Disable “Expensive” JDE Indexes

About By default, JDE creates a lot of database table index definitions.  When the “Generate Table” command is used in OMW, all of the JDE-defined Indexes are generated along with it.  But why does JDE have so many indexes to begin with? The reason for all of those predefined indexes really comes down to design …