About SQL execution plan change, which related to JDE invoicing
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.