Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-2006

Flag unused indexes on the database server

    • Type: Icon: New Feature New Feature
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Index Maintenance
    • 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 Unassigned
            Reporter:
            psadalag Pramodkumar Sadalage
            Votes:
            27 Vote for this issue
            Watchers:
            19 Start watching this issue

              Created:
              Updated:
              Resolved: