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
Last activity: Sep 15, 2014, 08:28 AM