Actual execution plan different from Explain plan, always.

Hello,

We have a slow running print job, from 10043 trace,  Oracle dose full table scans for a SQL like this:

SELECT  *  FROM PRODDTA.F4211

WHERE  ( SDDOC = :KEY1 AND SDDCT = :KEY2 ) 

ORDER BY SDDOCO ASC,SDDCTO ASC,SDKCOO ASC,SDLNID ASC

Both columns are indexed in a single index. From explain plans for both bind variable and value version, the access path is by index. The index is used when SQL is submitted in SQL*Plus, fetching is very fast.

The problem is in a custom JDEdware print job. The SQL is generated by print job process, no SQL hint can be given. Full table scan always happen.