SQL> set time on
16:56:32 SQL> analyze table dfk_sjcjtj compute statistics;
表已分析。
16:59:54 SQL> select * from dfk_sjcjtj where tjrq >= to_date('2011-06-30','
yyyy-mm-dd');
已选择15143行。
执行计划
----------------------------------------------------------
Plan hash value: 4090764313
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1319K| 61M| 4482 (1)| 00:00:54 |
|* 1 | TABLE ACCESS FULL| DFK_SJCJTJ | 1319K| 61M| 4482 (1)| 00:00:54 |
--------------------------------------------------------------------------------
Predicate Information (identifie