Community

EXPLAIN FORMAT=JSON provides insights on optimizer_switch effectiveness

(Sveta Smirnova) The previous post in the EXPLAIN FORMAT=JSON is Cool! series showed an example of the query select dept_name from departments where dept_no in (select dept_no from dept_manager where to_date is not null), where the subquery was materialized into a temporary table and then joined wit

Read More - Register for Free Membership