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.