Skip to Content
0
Dec 14, 2016 at 04:56 PM

IQ 16 SP11 PL03 - sql slow

112 Views

Disable for varchar and varbinary the use of maximum width ever inserted, rather than the declared maximum width

set temporary option dml_options14=8 ;

Apply this setting, SQL report runs fast; it has nothing to do data insert, a report SQL.

Where to find detail info for option dml_options14=8?