New optimizer hint for changing the session system variable.
In MySQL 8.0.3, we have introduced a new optimizer hint called SET_VAR. This hint allows to change the value of a system variable for a single query.
Earlier, changing a system variable for a single query would require four steps:
1) Store current value.
…
Source: New optimizer hint for changing the session system variable.
