Hi,

my issue got fixed with the help of excution plan. i was missing required non-clustered index on top of my table.

Thanks