search

awslabs / rds-support-tools

Amazon RDS Support Tools contains utilities, sql, scripts and views which are useful in a RDS environment
https://aws.amazon.com/rds/
Apache License 2.0
217 stars 229 forks source link

Add MySQL SQL script check-idx-btree-not-unique-redundancy.sql #41

Closed marozzin closed 7 years ago

marozzin commented 7 years ago

Add MySQL SQL script check-idx-btree-not-unique-redundancy.sql

Find single column B-Tree NOT UNIQUE indexes that are defined as prefix of another composed index too.

Note.

  1. Sigle B-Tree and NOT UNIQUE indexes are compared wich each composed index per table.

  2. Cases where the prefix index is unique are not considered as the uniqueness of the prefix index in this case enforce a constraint not enforced by the composed index.