sqldba_newbie (1/28/2013)
You still didnt answer my question.
i cant , without seeing the actual query exec plan (before changes and after changes), post the plans then based on that i will try.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)