oracle分区表统计分析拷贝,分区表的统计信息复制问题

SQL> set autotrace traceonly

SQL> SELECT * FROM test_part WHERE report_date=date'2011-11-09' AND flag1='1';

9 rows selected.

Execution Plan

----------------------------------------------------------

Plan hash value: 3658166

----------------------------------------------------------------------------------------------------

| Id  | Operation              | Name      | Rows  | Bytes | Cost (%CPU)| Time     | Pstart| Pstop |

----------------------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT       |           |     9 |   117 |     3   (0)| 00:00:01 |       |       |

|   1 |  PARTITION RANGE SINGLE|           |     9 |   117 |     3   (0)| 00:00:01 |     1 |     1 |

|*  2 |   TABLE ACCESS FULL    | TEST_PART |     9 |   117 |     3   (0)| 00:00:01 |     1 |     1 |

----------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

2 - filter("FLAG1"='1' AND "REPORT_DATE"=TO_DATE('2011-11-09 00:00:00', 'yyyy-mm-dd

hh24:mi:ss'))

Statistics

----------------------------------------------------------

0  recursive calls

0  db block gets

8  consistent gets

0  physical reads

0  redo size

604  bytes sent via SQL*Net to client

385  bytes received via SQL*Net from client

2  SQL*Net roundtrips to/from client

0  sorts (memory)

0  sorts (disk)

9  rows processed