Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.

Abstract: A method includes receiving a database query, analyzing system and session level variables to provide one or more identified variables, wherein each of the one or more identified variables corresponds to a system level variable or session level variable, determining if an optimizer changes setting is enabled, wherein the optimizer changes setting dictates whether or not existing variable values will be adjusted, identifying a selected value corresponding to each identified variable according to a cost analysis responsive to determining the optimizer changes setting is enabled, setting each identified variable to the corresponding selected value, and executing the received database query according to the one or more identified values. A computer program product and computer system corresponding to the method are also disclosed.