db2数据库有关创建表的问题
CREATE TABLE "PUB"."CITY" ("CITY_ID" CHARACTER(1) NOT NULL, "ODS_CITY_ID" DECIMAL(2, 0), "CITY_NAME" VARCHAR(150), "CITY_CODE" VARCHAR(6), "ZIP_CODE" VARCHAR(9), "BSS_AREA" DECIMAL(5, 0), &n...显示全部
查看其它 7 个回答IQHighest的回答
DATA CAPTURE NONE 控制日志记录的行为
参照：http://it.toolbox.com/blogs/db2- ... n-db2-logging-35334
IN "TBS_SSA_SML" 表所在的表空间
CCSID 双字节字符集为UNICODE
LOCKSIZE ROW 默认申请锁为行级锁
APPEND ON 新的数据会直接插入表尾部，而OFF则会先查找表中的可用空间
VOLATILE 表数据量变化较大时启用，优化器将对启用volatile特性的表考虑使用索引扫描而不是表扫描，而无论统计信息如何
LOG INDEX BUILD Specifies the level of logging that is to be performed during create, recreate, or reorganize index operations on this table. NULL Specifies that the value of the logindexbuild database configuration parameter will be used to determine whether or not index build operations are to be completely logged. This is the default when the table is created. OFF Specifies that any index build operations on this table will be logged minimally. This value overrides the setting of the logindexbuild database configuration parameter. ON Specifies that any index build operations on this table will be logged completely. This value overrides the setting of the logindexbuild database configuration parameter. 。
赚点米容易吗。。。感谢Google的大力支持~~~
参照：http://it.toolbox.com/blogs/db2- ... n-db2-logging-35334
IN "TBS_SSA_SML" 表所在的表空间
CCSID 双字节字符集为UNICODE
LOCKSIZE ROW 默认申请锁为行级锁
APPEND ON 新的数据会直接插入表尾部，而OFF则会先查找表中的可用空间
VOLATILE 表数据量变化较大时启用，优化器将对启用volatile特性的表考虑使用索引扫描而不是表扫描，而无论统计信息如何
LOG INDEX BUILD Specifies the level of logging that is to be performed during create, recreate, or reorganize index operations on this table. NULL Specifies that the value of the logindexbuild database configuration parameter will be used to determine whether or not index build operations are to be completely logged. This is the default when the table is created. OFF Specifies that any index build operations on this table will be logged minimally. This value overrides the setting of the logindexbuild database configuration parameter. ON Specifies that any index build operations on this table will be logged completely. This value overrides the setting of the logindexbuild database configuration parameter. 。
赚点米容易吗。。。感谢Google的大力支持~~~
浏览1039