• I dont think you will get much help here unless you provide defintion of view along with index/table defintion.

    please post them.

    and by the way how did you find the perfoemance issue ? exec plan ? if yes post that too .

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)