Everybody knows that indexes can boost SELECT performance, but how do you verify that you are using index correctly? In this session, I'll explain detailed mechanism of traditional MySQL B+Tree indexes, optimizer plans, and how to boost performance. Not only speeding up SELECT, but also speeding INSERT are covered.