New optimizer hint for changing the session system variable.
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.