Originally posted by elaine3839
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.
Is this what you have partitioned on?


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?
The num_rows only shows up after you have analyze the table.

Also, if you didn't analyze the table AFTER you put data into it, your indexes will probably not be used. Hence, maybe problem in #1 also.