For performing single primary select, SELECT
uses the mysql_select
function, which does:
allocate
JOIN
JOIN::prepare
JOIN::optimize
JOIN::exec
JOIN::cleanup
In previous versions of MySQL, all SELECT
operations were performed with the help of this function and
mysql_select()
was not divided into parts.