streamlined dynamic SQL

streamlined dynamic SQL enables the statement cache to store dynamic SQL statements.

Summary Information
Default value	0 (off)
Valid values	0 (off), 1(on)
Status	Dynamic
Display level	Comprehensive
Required role	System administrator
Configuration group	Application Functionality

Note: The default value for streamlined dynamic SQL depends on the value to which enable functionality group is set. If you set enable functionality group to:

0 – the default value for streamlined dynamic SQL is 0.
1 – the default value for streamlined dynamic SQL is 1.

However, if you set streamlined dynamic SQL to 1, it uses a value of 1 regardless of what you set enable functionality group to.

See enable functionality group.

See Performance and Tuning Series: Basics > Memory Use and Performance.