where
clause makes it impossible to find some values in certain partitions. PARTITION_START
and PARTITION_STOP
(for example in the plan_table
). OPERATION
and OPTIONS
. where
clause on a date
column of a partitioned table only executes partition pruning if to_date()
function and a 4-digit format mask and
to_date
with a 2 or 4 digit mask is also used in the where
clause.