Skip to Content
avatar image
Former Member

Lis most used indexes

Dear all,

I would like to rebuild most used indexes from my server ( SAP on Oracle ). I am quite new in this, is there any way to check somehow most used indexes that can be rebuilt ?

Any advice is welcomed,

Thanks,

J.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 14, 2012 at 10:56 AM

    Hi,

    why would you like to do so?

    I recommend to do a google search for several Articles/Blogs from Richard Foote concerning this topic.

    Yes, rebuilding indexes can help in some cases, but you should not do this just for the fun of it, and

    "most used" is certainly the worst criteria to be chosen, when to decide which one to rebuild.

    There are several others that would be more relvant.

    Volker

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Volker Borowski

      Thanks Volker,

      Cleared my mind, and changed my plans 😊 I will let you know what have been done after the investigation.

      Have a good day,

      J,🤪