Verify yourself to prove that you are not a ROBOT! After verification the page will apear. Thanks for understanding.
I have a sql query (Part of a procedure) like this:-
DECLARE ab INT;
SET ab = 1;
SELECT * FROM `table1` LEFT OUTER JOIN
`table1`.`columnfromtable1`=`table2`.`columnfromtable2` AND ab=0;
My question is 'what is the sql engine's first job?'
Every time you want to know if an index is used or how a query is performed you should use the explain syntax.
When EXPLAIN is used with an explainable statement, MySQL displays information from the optimizer about the statement execution plan.
And this is valid for any query, not only this one.
You only need to understand the EXPLAIN Output Format.