• THanks for reply,

    update stastics has been updated upto date.

    i have checked fragmentation and are fine...

    Can you tell me how to find the missing indexes for high usage tables....