In Microsoft SQL Server you can see Execution Plans for queries to see how a query is executed, what joins take the most time and see any missing indexs
now i want to do the same for MySQL scripts that run on a MySQL Server, i am wondering what programs or tools i can uses for this
EDIT: we have MySQL 5.5 running on Wamp and the development server so we can't use EXPLAIN
EXPLAIN
however from what i've read it's really only used forSELECT
queries, that's good if all i did wasINSERT INTO ... SELECT
however i also have alot ofUPDATE
queries i want checked out aswell