Flag unused indexes on the database server

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Index Maintenance
    • None
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      As we develop apps and have indexes, over a period of time the usage of the app will change and some of the indexes will not get used. If the server can tell us what indexes are being used and which are not being used then it would be great, so that we can removed UNUSED indexes thus saving on Index Updates during insert/update/delete and also more of the used indexes can be fit in RAM.

      Oracle has this feature.

            Assignee:
            Unassigned
            Reporter:
            Pramodkumar Sadalage
            Votes:
            27 Vote for this issue
            Watchers:
            19 Start watching this issue

              Created:
              Updated:
              Resolved: