📄️ SET
Changes the value and/or level of a system setting. To show all the current settings, use SHOW SETTINGS.
📄️ UNSET
Set one or more system settings back to their default values. The settings will also be reset to the initial SESSION level if they were set to GLOBAL level. See Examples for how to reset a GLOBAL setting with UNSET. For more information about the setting levels, see Managing Settings. To show all the current settings, use SHOW SETTINGS.
📄️ SET_VAR
SET_VAR is used to specify optimizer hints within a single SQL statement, allowing for finer control over the execution plan of that specific statement. This includes: