Mview not being used - Query Rewrite
I'm trying to optimize the following query by using a materialized view.
SELECT D.FIRST_PARTY_KEY AS FIRST_PARTY_KEY,D.SECOND_PARTY_KEY AS SECOND_PARTY_KEY, D.RELATION_TYPE_CD AS RELATION_TYPE_CD, D.ROW_UPDATE_DATE AS ROW_UPDATE_DATE, D.CUSTOM_FIELD AS CUSTOM_FIELD,D.IS_ACTIVE AS IS_ACTIVE, D.CSM1 AS CSM1,D.CSM2 AS CSM2, D.CSM3 AS CSM3, D.CSM4 AS CSM4, D.CSM5 AS CSM5,D.CN1 AS CN1, D.CN2 AS CN2, D.CN3 AS CN3, D.CN4 AS CN4, D.CN5 AS CN5,D.CB1 AS CB1, D.CB2 AS CB2, D.CB3 AS CB3, D.CB4 AS CB4, D.CB5 AS CB5,D.CD1 AS CD1, D.CD2 AS CD2, D.CD3 AS CD3, D.CD4 AS CD4, D.CD5 AS CD5,D.OWNERSHIP_PERCENT AS OWNERSHIP_PERCENTFROM PARTY_PARTY_REL_H_LATEST D Inner Join PARTY_H_LATEST PARTY_POPULATIONOn ( D.FIRST_PARTY_KEY = PARTY_POPULATION.PARTY_KEY OR D.SECOND_PARTY_KEY = PARTY_POPULATION.PARTY_KEY )AND PARTY_POPULATION.IS_ACTIVE = 'Y' AND D.IS_ACTIVE = 'Y'INNER JOIN CDD_PRF_PARTY_BATCH PARTY_BATCH
0