-
Unused indexes
DBAs,
We have a troublesome application whose performance is very poor.
I turned on the monitoring for all the indexes belonging to that application.
After 24 hours monitoring, I found 210 out 425 indexes have not been used.
60% of those unused indexes are foreign key related.
Can I get rid of those unused indexes?
Especially those on the big tables.
Is it a good idea?
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|