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 …
-