optimizer level

Summary information
Default value	ase_default
Range of values	ase_current – Enables all optimizer changes through the current release ase_default – Disables all optimizer changes since version 1503 ESD #1 ase1503esd2– Enables all optimizer changes through version 15.0.3 ESD #2 ase1503esd3 – Enables all optimizer changes through version 15.0.3 ESD #3
Status	Dynamic
Display level
Required role	System administrator
Configuration group	Query Tuning

optimizer level determines the level of optimization the query processor uses. See Chapter 7, Controlling Optimization, in the Performance and Tuning Series: Query Processing and Abstract Plans for information about optimization levels.

The values for optimizer level are character data, so you must use 0 as a placeholder for the second parameter, which must be numeric.