• Hi

    It depends what indexes were changed. If it was a clustered index, then have in mind that REBUILD-ing it does not rebuild the associated nonclustered indexes automatically unless the ALL keyword is specified.

    It's the same for re-creating a clustered index. If it was the case, than practically, you have the nonclustered indexes useless.

    Regards,

    Igor Micev

    Igor Micev,My blog: www.igormicev.com