• Thanks for reply!

    Earlier I was collecting data in some temporary table so that I can use it as input to query on main table. Now I have removed that part and created another non clustered index on that table on field SALESCOMPANY(as per suggestion from Senior person) and querying data on main table directly.

    Now performance is shortened to almost half time.

    I hope it is acceptable 🙂