📄 partdml.out
字号:
Index Scan ResultSet for BASIC using index B4 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched=All ij> update basic set ccharForBitData = ccharForBitData where cint = 11;1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B4 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched=All ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME |CDEC |CINT |CCHAR ----------------------------------------------11 |11:11:11|1.10 |11 |11 22 |22:22:22|2.20 |22 |22 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1 -----------1 ij> update basic set cint = cint where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 1, 2, 4}ij> update basic set cchar = cchar where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B1 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched={0, 1, 2, 3}ij> update basic set ctime = ctime where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 2, 4}ij> update basic set cdec = cdec where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={3, 4}ij> update basic set ccharForBitData = ccharForBitData where ccharForBitData = x'11';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B1 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched={0, 1, 2, 3}ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME |CDEC |CINT |CCHAR ----------------------------------------------11 |11:11:11|1.10 |11 |11 22 |22:22:22|2.20 |22 |22 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1 -----------1 ij> autocommit off;ij> update basic set cdec = cint;12 rows inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 3}ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME |CDEC |CINT |CCHAR ----------------------------------------------11 |11:11:11|11.00 |11 |11 22 |22:22:22|22.00 |22 |22 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 33 |03:33:33|33.00 |33 |33 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1 -----------1 ij> rollback;ij> update basic set cchar = cchar where cdec = 3.3 and ctime = TIME('03:33:33');10 rows inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 1, 2, 3, 4}ij> update basic set ctime = ctime, cchar = cchar, cint = cint, cdec = cdec, ccharForBitData = ccharForBitData;12 rows inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------TableScanBit set of columns fetched={0, 1, 2, 3, 4}ij> -- confirm the table is okselect ccharForBitData, ctime, cdec, cint, cchar from basic;CCH&|CTIME |CDEC |CINT |CCHAR ----------------------------------------------11 |11:11:11|1.10 |11 |11 22 |22:22:22|2.20 |22 |22 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 33 |03:33:33|3.30 |33 |33 ij> values (SYSCS_UTIL.SYSCS_CHECK_TABLE('APP', 'BASIC'));1 -----------1 ij> ---------------------------------------------------------------------------- deletes------------------------------------------------------------------------------ index scans--delete from basic where cchar = '22';1 row inserted/updated/deletedij> values getScanCols(SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS());1 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Index Scan ResultSet for BASIC using index B1 at read committed isolation level using exclusive row locking chosen by the optimizerBit set of columns fetched=All ij> rollback;ij> delete from basic where cint = 22;⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -