Web Exception with Full Table Scan Issue on F1307 Table

 Hello All,

We have a vague issue in production with one of JDE work order creation application (standard). The Work order application is failing with web exception due to the due to the full table scan on F1307. the usual update on this table takes about 2 seconds but it is not picking the right index in production environment and going for full scan. where as the same application work with same data in CRP environment. the production system is currently suffering for the last 3 weeks and we have given them the alternative by mapping the table in CRPDTA to continue