Post reply

saving current indexes prior to using perfrmance advisor''s recommendations

  • August 27, 2007 at 7:51 am

    #69943

    I'm getting ready to apply performance advisor's recommendations for my db's indexes. Many of the recommendations are to drop current indexes (which I'm pretty much in agreement with). Because I'm the cautious type, I'd like to be able to save the current index scheme prior to dropping a bunch of indexes in case performance is made worse and I want to go back to the original scheme. Is there some way to do this?

    Thanks,

    Jim

  • August 27, 2007 at 8:16 am

    #729543

    Right click the db, Generate Scripts. Be sure indexes are checked and save this file.

  • August 27, 2007 at 12:10 pm

    #729614

    Thanks for ths tip.  I tried it and it seems to do the trick however, it also scripts the "create table" commands. Do you know of a way to exclude those commands (I tried setting everything except indexes to false)?

    Thanks,

    Jim

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply