1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
| dev001> set autot off
dev001>
dev001> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production
dev001>
dev001> drop table t;
Table dropped.
dev001>
dev001> create table t
2 (c1 int primary key,
3 c2 varchar2(100)
4 );
Table created.
dev001>
dev001>
dev001> begin
2 for i in 1.. 10000
3 loop
4 insert into t
5 values (i, to_char(i));
6 end loop;
7 commit;
8 end;
9 /
PL/SQL procedure successfully completed.
dev001> show errors
No errors.
dev001>
dev001> exec dbms_stats.gather_table_stats(ownname => 'TEST', tabname => 'T', cascade => true);
PL/SQL procedure successfully completed.
dev001>
dev001> set autot traceonly explain
dev001> select count(*) from t;
Execution Plan
----------------------------------------------------------
Plan hash value: 1282900848
-----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 5 (0)| 00:00:01 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | INDEX FAST FULL SCAN| SYS_C003048 | 10000 | 5 (0)| 00:00:01 |
----------------------------------------------------------------------------- |
Partager