Have A, B, C three table, A table is A composite partition table (range, A list), table B is created through A table primary key as A foreign key reference partitions, C table is the foundation of the general information table,

SQL 1:
Select * from a, b where a. d. ate & gt;=to_date (' 2018-01-01 ') and a. d. ate
The partition pruning success

Sql2:
Select * from a, b, c where a. d. ate & gt;=to_date (' 2018-01-01 ') and a. d. ateAnd c.i d=b.i temid;
The partition pruning failure,

Does anyone know what reason be?

CodePudding user response:

Didn't understand want to ask what problem,
You this is a table and b, c have no associated conditions, this is not a cartesian product