How does Oracle estimate cardinality on a partitioned table if the query gets the list of partitions from a subquery or a join?
For example, if I have a query like this
select * from partitioned_table join list_of_partitions using (part_key)
list_of_partitions is a small table (single row per partition key)
What estimate gets used for
Since Oracle doesn't know exactly what partitions are accessed when the query is parsed, where would the estimate come from?