May the Index be with you!


The summer’s end is rapidly approaching — in the next two weeks or so, most people will be settling back into work. Time to change your mindset, re-evaluate your skills and see if you are ready to go back from the picnic table to the database table.

With this in mind, let’s see how much folks can remember from the recent indexing talks my colleague Zardosht Kasheff gave (O’Reilly Conference, Boston, and SF MySQL Meetups). Markus Winand’s site “Use the Index, Luke!” (not to be confused with my favorite Star Wars parody, “Use the Schwartz, Lone Starr!”), has a nice, quick 5 question indexing quiz that can help with this.

How did you do on the quiz? (I’ll wait….)

If you didn’t pass, no worries. It’s time for a quick refresher summer school class! Here’s Zardosht’s talk and slides.

Now, some of you surely aced the test and are looking for extra credit. For this, we offer some advanced material on a topic we frequently get asked about – clustering indexes. See our prior blogs on Introducing Multiple Clustering Indexes and Clustering Indexes vs. Covering Indexes. In TokuDB, we have added functionality and grammar syntax to define multiple clustered indexes. As a result, users can get the performance advantages of clustered indexes for multiple indexes.

Congrats on making it through the refresher. Enjoy the end of the summer, and “may the index be with you!”

Share this post