Hello friend,

Please check your index status, If index fragmention have been over 30% then need reorganize index. If table is very big then make a plan Index re-organization on alternate days.

If you are using In function in stored procedure then you can change it in Inner join. your performance will be better.

Rajesh Singh

DBA(HCL Comnet)

+91-9560888360