Description Former Value Applied Value
-------------------------------------------------------------------------------------------------
Work Action SYSMAPMANAGEDQUERIES Enabled = Y Y
Work Action Set SYSDEFAULTUSERWAS Enabled = Y Y
Work Class SYSMANAGEDQUERIES Timeroncost = 1.50000E+05 1.50000E+05
Threshold SYSDEFAULTCONCURRENT Enabled = N Y
Threshold SYSDEFAULTCONCURRENT Maxvalue = 13 13
DB210203I AUTOCONFIGURE completed successfully. Database manager or database
configuration values may have been changed if you chose to apply changes. The
instance must be restarted before any such applied changes come into effect.
You may also want to rebind your packages after the new configuration
parameters take effect so that the new values will be used.
可以看到DFT_TABLE_ORG的值由row修改为column了，也就是以后创建的表默认就是列式存储表了，据测试来看列式存储确实在空间使用和SQL查询效率上提高了很多，不过改特性只能支持单表的，对于分表/DPF/MDC/PureScale环境下的表还是不能支持的，好，现在就说初步了解下，以后会有更多的实际应用案例吧。