B-tree indexes, composite indexes, EXPLAIN, query optimization, covering indexes, and slow query log.