Showing entries 1 to 1
Displaying posts with tag: redundant indexes (reset)
MySQL UC2008 presentation "Grand Tour of the information schema" now online

Yup, the presentation slides as well as the scripts are now available online on the conference website.

The stuff you will find in there:

Information_schema.pdf
Diagram of the information schema
I_S_VC_Slides.pdf
Slides for the UC presentation, "Grand Tour of the Information Schema"
I_S_INDEXES2.sql
script, returns one row for each index (rollup of information_schema.STATISTICS)
I_S_REDUNDANT_INDEXES2.sql
script, 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 …
[Read more]
Showing entries 1 to 1