Sample Header Ad - 728x90

When is it safe to drop redundant or duplicated indexes on AWS RDS MySQL?

1 vote
1 answer
107 views
To identify redundant and duplicate indexes while ignoring primary and foreign keys and checking their cardinality. What is the best practice for dropping indexes on AWS RDS MySQL databases in the AWS RDS environment? My environment(context): AWS RDS Aurora MySQL 8.0 The purpose is to reduce storage costs and improve INSERT/UPDATE/DELETE transactions.
Asked by Jayron Soares (13 rep)
Aug 2, 2024, 12:10 AM
Last activity: Aug 2, 2024, 09:12 PM