hi

Pavb also asked you if you an index on APPNM column?

Can you also post the explain plan for that query

regards
Hrishy