-
Type: New Feature
-
Resolution: Duplicate
-
Priority: 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.
- duplicates
-
SERVER-44432 Per index access stats
- Closed
- is duplicated by
-
SERVER-3271 Feature Request: Add index usage counters that are queriable so we can see which indexes are unused or sparsely used
- Closed