I still think you miss an index on NGPROJGUID. The easyest way to bring back the fast plan is to hint the query.
Are the indexes NGUSRFLD6_IND and NGUSRFLD2_IND function based? If not, they still cannot be used as appropriate
|
Results 1 to 10 of 15
Thread: db file sequential readThreaded View
|
Click Here to Expand Forum to Full Width |