Skip to content

Instantly share code, notes, and snippets.

@ylacancellera

ylacancellera/mysql_optimizer_switch_8

Created December 30, 2022 11:51
Show Gist options
  • Save ylacancellera/5899981b309d5ff1c0ddc689fa6a9e4e to your computer and use it in GitHub Desktop.
Save ylacancellera/5899981b309d5ff1c0ddc689fa6a9e4e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_optimizer_switch_8
set optimizer_switch='use_invisible_indexes=on';
set optimizer_switch='skip_scan=off';
set optimizer_switch='hash_join=off';
set optimizer_switch='subquery_to_derived=on';
set optimizer_switch='hypergraph_optimizer=on';
set optimizer_switch='derived_condition_pushdown=off';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment