IBM Support

Model Converter: what does converting to 'Incremental Optimization' in SQL2014 do to the database??

Question & Answer


Question

Model Converter: what does converting to 'Incremental Optimization' in SQL2014 do to the database??

Answer

It enables incremental statistics, which must be used for SQL2014 Enterprise databases.? It causes the statistics to be computed in a more efficient way that was introduced as part of SQL2014.

Version 9.0.2

[{"Business Unit":{"code":"BU051","label":"N\/A"},"Product":{"code":"SUPPORT","label":"IBM Worldwide Support"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB33","label":"N\/A"}}]

Document Information

More support for:
IBM Worldwide Support

Software version:
All Versions

Document number:
781211

Modified date:
02 November 2020

UID

ibm10781211