Hi,

As part of performance tuning, I created a partitioned table and inserted about 12 million rows to this table by using

insert * into tbl_part select * from tbl_old;

The new table has 12 different partitions based on calldate.

2 questions:

1. when I tried to run a query against this new table, a full table scan still occurs instead of using just that partition. Why?
note: that query's where clause does use calldate as a range.

2. When I look at user_tab_partitions, the num_rows are null for each partition of the newly created partition table, while I was expecting to see all different values based on the number of records in that partition. Did I miss anything?

Thanks a lot!