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.

About KENNETH 8407 Articles
지락문화예술공작단

Be the first to comment

Leave a Reply

Your email address will not be published.


*