How MySQL Uses Internal Temporary Tables

by satheeshkumar 2012-09-19 23:02:30

How MySQL Uses Internal Temporary Tables ,

->Temporary tables can be created under conditions such as these:
->If there is an ORDER BY clause and a different GROUP BY clause, or if the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue, a temporary table is created.
->DISTINCT combined with ORDER BY may require a temporary table.
->If you use the SQL_SMALL_RESULT option, MySQL uses an in-memory temporary table, unless the query also contains elements (described later) that require on-disk storage.
610
like
0
dislike
0
mail
flag

You must LOGIN to add comments