CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

About SQL execution plan change, which related to JDE invoicing

edited Nov 21, 2014 10:00AM in CNC, DB and Operating System - JDE1 (MOSC) 3 commentsAnswered

Hey, there,

I just have a question about the following query inside a database that supports JD Edwards EnterpriseOne product. Has anyone see a similar SQL query like the following (from Service Billining):

SELECT * FROM F4812 WHERE ( WDICU = :KEY1 AND WDDOCZ = :KEY2 AND WDDCTI = :KEY3 AND WDKCOI = :KEY4 AND WDSFX = :KEY5 ) AND ( ( WDCO = :KEY6 OR WDCO = :KEY7 OR WDCO = :KEY8 OR WDCO = :KEY9 ) ) ORDER BY WDICU ASC,WDDOCZ ASC,WDDCTI ASC,WDKCOI ASC,WDSFX ASC

There is an index F4812_2 on (WDICU, WDDOCZ, WDDCTI, WDKCOI, WDSFX) precisely.  It used to use index F4812_2. BUT, it suddenly stopped using it and started table-scans. If you have encountered similar issues, could you please help a bit.

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