Skip to Content
0
Former Member
May 13, 2013 at 09:14 AM

indexes old and new

30 Views

typical situation where a user complains that his stored proc is not performing the way it used to.

how do i verify if the table has all the indexes it used to have? ie how to verify if there were indexes which could have been dropped etc?

any system table or system logs where i could find this information?

appreciate the feedback.