Sample Header Ad - 728x90

How are derived table implemented in MySQL

0 votes
2 answers
370 views
When MySQL makes a derived table as a result of SELECT (SELECT ...) etc or SELECT * FROM a JOIN (SELECT * from B) etc or SELECT * FROM (SELECT ...) Are these derived temporary tables created in-memory or the file-system? Does it depend on the size of the derived table?
Asked by Cratylus (1013 rep)
Sep 14, 2014, 06:31 PM
Last activity: Sep 15, 2014, 08:28 AM