Thanks again to Erin O’Neill and Mike Tougeron for having me at the SF MySQL Meetup last month for the talk on “Understanding Indexing.” The crowd was very interactive, and I appreciated that over 100 people signed up for the event and left some very positive comments and reviews.
Thanks to Mike, a video of the talk is now available:
As a brief overview – Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase application performance is to optimize the indexes. This talk presents three simple and effective rules on how to construct indexes around queries that result in good performance.
“Director’s Cut” Bonus Feature: During the talk, a number of people wanted the lowdown on Fractal Tree™ Indexing. After the first hour on general indexing, I was able to address this and give a whiteboard overview of Fractal Tree indexes: