EXPLAIN and DESCRIBE
EXPLAIN Select query
DESCRIBE tablename