duplicate-index (GN025)

Automatic fix is not available.

What it does

Checks for duplicate indexes (exact match).

Why not?

Having duplicate indexes can negatively affect performance of database operations in several ways, some of which are as follows:

• Slower Write Operations
• Maintenance Overhead
• Increased Storage Costs

In summary, indexes are not cheap and what is worst is having them duplicated.

When should you?

Never.

Use instead:

Remove the duplicate.