Quote:
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?
Quote:
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.