Is there a equivalent way to see the execution plans from MYSQL like the set showplan on command in Sybase ASE?
set showplan on
You can use the EXPLAIN statement.