Hello All!
I have three tables.A is range-list composite partition table by column cdate and type.
B is a reference partition table By FK reference A 's primary key.C is a no-partitioned table( Basic information dictionary table).
the first sql statement ：
select * from a inner join b on a.id=b.id where a.cdate between to_date('2020-01-01','yyyy-mm-dd') and to_date('2020-12-01','yyyy-mm-dd') and a.type='xx';
the partition pruning is work
the second sql statement：
select * from a inner join b on a.id=b.id
inner join c on b. infoid=c.id
where a.cdate between to_date('2020-01-01','yyyy-mm-dd') and to_date('2020-12-01','yyyy-mm-dd') and a.type='xx';
the partition pruning is not work.
I want to know the reason