7 Replies Latest reply: May 8, 2012 10:53 PM by user578946 RSS

    Base line comparision recommendations after setting 100 redundent indexes

    user578946
      1) I'm planning to mark 100 redundant indexes invisible in production database. And i verified they are redundant, but i would like to measure the performance of the database before i mark them invisible vs after. And if it all looks good the plan is to drop them after some time.

      So my question is what is the best way to bench mark this db version 11.2.0.2

      My plan: My plan is to compare the AWR report periods in cluster wide before and after making indexes invisible. I just want to know is there any other better option to compare the performance of database.

      Edited by: user578946 on May 8, 2012 12:39 PM