Dynamic sampling on partitioned table
Hi ,
Our oracle database is 12.1.0.2 , we have a huge partitioned table with interval partitions and each partition has about 32 hash sub partitions
Statistics have been collected at table and partition level. Thr hash sub partitions do not have statistics collected
The global_stats on the table and partitions is YES
While for the sub partitions the global stats is NO
There are no stale stats in the table
Still when I run a query on the table with a where clause , the explain plan shows it is using dynamic sampling instead of optimizer statistics. It is doing a full table scan.