• hmm I have dropped the index anyway (moreover, I noticed the statistic of the unused index is quite convincing )...

    btw how do we find out which stored proc that use that index ? I really have no idea about it because we have a lot of SP ...

    Pls kindly response

    Thanks a lot ...