MySQL Internals Manual  /  How MySQL Performs Different Selects  /  SIMPLE or PRIMARY SELECT

12.3 SIMPLE or PRIMARY SELECT

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.


User Comments
Sign Up Login You must be logged in to post a comment.