oracle truncate很慢,【求教大侠:Truncate速度为什么比delete还慢???】-Oracle论坛-ZOL中关村在线...

My test result is different from yours

22:11:38 SQL> create table ycltest as select * from dba_objects;

Table created.

Elapsed: 00:00:03.79

22:12:06 SQL> select count(*) from ycltest;

COUNT(*)

----------

47648

Elapsed: 00:00:00.32

22:12:25 SQL> alter session set events '10046 trace name context forever,level 1

2';

Session altered.

Elapsed: 00:00:00.09

22:13:22 SQL> delete from ycltest;

47648 rows deleted.

Elapsed: 00:00:06.86

22:13:42 SQL> rollback

22:13:48   2  ;

Rollback complete.

Elapsed: 00:00:11.64

22:14:01 SQL> truncate table ycltest;

Table truncated.

Elapsed: 00:00:00.70

22:14:13 SQL>