Skip to Content
avatar image
Former Member

IQ 16 SP11 PL03 - sql slow

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 15, 2016 at 08:21 AM

    Rey

    I remember seeing a related problem in Cr 799266

    https://launchpad.support.sap.com/#/notes/2324233/E

    Regards

    John

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31, 2017 at 11:52 AM

    Hi,

    See the latest SAP IQ Updates in the following Document - SAP First Guidance – SAP-NLS Solution with SAP IQ

    Best Regards Roland

    Add comment
    10|10000 characters needed characters exceeded