Hi all,
I have the following materialized view based on the following query
SELECT T2.COMMUNICATION_CD , MAX(T1.CONTACT_DTTM) AS MAX_CONTACT_DTTM
FROM CI_CONTACT_HISTORY_BKP T1 ,
CI_CELL_PACKAGE T2
WHERE
T1.CELL_PACKAGE_SK=T2.CELL_PACKAGE_SK
AND T1.CONTACT_DTTM > SYSDATE-180
GROUP BY T2.COMMUNICATION_CD;
where CI_CONTACT_HISTORY_BKP is a partitioned table based on a range partition on CONTACT_DTTM ( I have a partition for each month). In Attachment the explain plan.
It is possible to improve the performance? In production environment the execution time is between 200 and 300 sec.
Thanks for all.
Regards.