What does it mean MATERIALIZED in the select_type column in the result of MySQL Explain closure?

Question

I just got the next result of MySQL Explain closure:

And I, unfortunately, don't understand what does it mean MATERIALIZED in the last row of the select_type column.

If somebody knows what does it mean please give me any advice to study in this question or give me the answer to it.

https://stackoverflow.com/questions/3029841/sql-explain-plan-what-is-materialize — Vykintas, Dec 11 '19 at 09:47

score 8 · Accepted Answer · answered Dec 11 '19 at 11:09

8

It means that the result of a subquery was saved as a virtual temporary table instead of executing it for each row. This was introduced in MySQL 5.7 and speeds up some queries that were super slow before due to the fact the result of their subquery parts wasn't cached

answered Dec 11 '19 at 11:09

Alexey

2,388
1
16
32

Thanks! It's a brilliant intelligible answer! – Alexander Leon Bulatov Dec 11 '19 at 13:59

What does it mean MATERIALIZED in the select_type column in the result of MySQL Explain closure?

1 Answers1