Why no partition pruning?
Hi All,
Could some body help me in identifying the root of this issue. I have a table TRA_PART which is partitioned by TRA_SIT_ID column. When I compare this column with a hard coded list then partition pruning happens but when i compare with a column of another table pruning is not happening. Both tables's stats are up-to-date.
EXPLAIN PLAN FOR
SELECT
tra_sec_id AS SEC_ID,
SYSDATE AS TIMESTAMP
FROM
CRIS.tra_PART,
dcsw_owner.MV_UBR_CAM_TAB MV_UBR_CAM
WHERE 1=1
AND tra_sit_id IN ('TE','TD','TO')
AND tra_sit_id = MV_UBR_CAM.SIT_ID
Could some body help me in identifying the root of this issue. I have a table TRA_PART which is partitioned by TRA_SIT_ID column. When I compare this column with a hard coded list then partition pruning happens but when i compare with a column of another table pruning is not happening. Both tables's stats are up-to-date.
EXPLAIN PLAN FOR
SELECT
tra_sec_id AS SEC_ID,
SYSDATE AS TIMESTAMP
FROM
CRIS.tra_PART,
dcsw_owner.MV_UBR_CAM_TAB MV_UBR_CAM
WHERE 1=1
AND tra_sit_id IN ('TE','TD','TO')
AND tra_sit_id = MV_UBR_CAM.SIT_ID
0