The purpose of this article is to explain (mainly to myself) a technique for creating good indexes for mysql database.