USE db_name; EXPLAIN select * from tbl_name where ... like '%'; EXPLAIN EXTENDED select * from tbl_name where ... like '%';
-- dazu dann oft auch SHOW INDEX FROM tbl_name;