CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Wrong Index used on AS400

edited Aug 30, 2013 7:49AM in CNC, DB and Operating System - JDE1 (MOSC) 4 commentsAnswered
We have been running the R077011 - Tax History Integrity for years.  It used to run in 15-20 minutes on the AS400. Recently we added custom indexes to F06166.  It used to have 7 indexes , now it has 11 indexes.  The R077011 references using Index 6 of the F06166 when doing a Select Fetch Next.  We notice on the AS400 when it is running that it is now using Index 9. It now runs in 3+hrs.  So it appears that we know what the problem is, but we don't know how to fix the problem.  We do regular deletion of SQL packages.  What could have caused

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center