PLSQL批量Forall操作性能提升详解
首先创建测试表
CHANGE #2 TYP:0 CLS:1 AFN:4 DBA:0x0100e283 OBJ:80824 SCN:0x0000.01050dc3 SEQ:3 OP:11.11 ENC:0 RBL:0KTB Redoop: 0x01 ver: 0x01 compat bit: 4 (post-11) padding: 1op: F xid: 0x0002.00b.00000669 uba: 0x00c01762.00f1.0fKDO Op code: QMI row dependencies Disabled xtype: XA flags: 0x00000000 bdba: 0x0100e283 hdba: 0x0100eeeaitli: 1 ispac: 0 maxfr: 4858tabn: 0 lock: 1 nrow: 255slot[0]: 0tl: 12 fb: --H-FL-- lb: 0x0 cc: 3col 0: [ 2] c1 02col 1: [ 2] c0 33col 2: [ 2] c1 02slot[1]: 1tl: 11 fb: --H-FL-- lb: 0x0 cc: 3col 0: [ 2] c1 03col 1: [ 2] c1 02col 2: [ 1] 80slot[2]: 2tl: 13 fb: --H-FL-- lb: 0x0 cc: 3col 0: [ 2] c1 04col 1: [ 3] c1 02 33col 2: [ 2] c1 02slot[3]: 3tl: 11 fb: --H-FL-- lb: 0x0 cc: 3col 0: [ 2] c1 05col 1: [ 2] c1 03col 2: [ 1] 80....slot[254]: 254tl: 15 fb: --H-FL-- lb: 0x0 cc: 3col 0: [ 3] c2 03 38col 1: [ 4] c2 02 1c 33col 2: [ 2] c1 02
