If you need indexes, MySQL will EXPLAIN
Setting up indexes is essential to keeping your queries nice and quick. Adding an index is easy – if you’re using phpMyAdmin, just find your table, click “Create an Index” and choose your column or columns. Adding the right indexes is not easy and can be a bit hit-and-miss. This is where the handy EXPLAIN…