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

Flag unused indexes on the database server

    XMLWordPrintableJSON

Details

    • Icon: New Feature New Feature
    • Resolution: Duplicate
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Index Maintenance
    • None

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: