The stuff you will find in there:
Information_schema.pdfDiagram of the information schema
I_S_VC_Slides.pdfSlides for the UC presentation, "Grand Tour of the Information Schema"
I_S_INDEXES2.sqlscript, returns one row for each index (rollup of information_schema.STATISTICS)
I_S_REDUNDANT_INDEXES2.sqlscript, lists all redundant indexes. Redundancy rules:
- two indexes with the same columns, type and uniqueness are interchangeable. The one with the largest index name is listed as redundant
- if there is a unique index and a non unique index with the same columns and type exists, the non-unique one is considered redundant