7013
7013
2 SUBQUERY t1 index a a 5 NULL 2 Using where; Using index
7014
7014
2 SUBQUERY t2 ref b b 5 test.t1.a 2 Using index
7016
7024
set optimizer_switch=default;
7017
7025
select @@optimizer_switch like '%subquery_cache=on%';
7018
7026
@@optimizer_switch like '%subquery_cache=on%'