Worksheet

Slow report index worksheet

Each slow report gets a line. Columns hold report name, table, filter columns in order, sort column, rows in the table, EXPLAIN type before and after, index added, and the write cost the developer noted.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “MySQL indexes explained: why one report is slow and another is fast”, www.gullysystem.com/blog/mysql-indexes-explained-why-one-report-is-slow-and-another-is-fast