oracle 变量 弊端,什么时候oracle使用绑定变量性能反而更差

满意答案

东方明亮DF

2015.04.07

采纳率：57%    等级：7

已帮助：8人

SQL> create table T_PEEKING (a NUMBER, b char(1), c char(2000));

Table created.

SQL>

SQL> create index T_PEEKING_IDX1 on T_PEEKING(b);

Index created.

SQL> begin

2 for i in 1..1000 loop

3 insert into T_PEEKING values (i, 'A', i);

4 end loop;

5

6 insert into T_PEEKING values (1001, 'B', 1001);

7 insert into T_PEEKING values (1002, 'B', 1002);

8 insert into T_PEEKING values (1003, 'C', 1003);

9

10 commit;

11 end;

12 /

PL/SQL procedure successfully completed.

00分享举报