Performance issue on IFS data mart refresh. We have identified a performance issue for a customer, FACT_PROJECT_CONN_DET is taken 3 + hours to do internal IFS data mart refresh. The Refresh for FACT_PROJECT_CONN_DET is taking 3+ hours to run on each refresh. They have set a separate refresh category to run this overnight, but as they informed it is now impacting their month end process as they cannot run data mart jobs in parallel. With the timely manner performance issue got worse up to 9+ hours with the growing data load of 7+ million in the environment. Note:Highest time-consuming SQL query running when refresh data mart for FACT_PROJECT_CONN_DET. INSERT INTO PROJECT_CONN_DET_MVTSELECT * FROM ( SELECT F.*FROM PROJECT_CONN_DET_MVS FWHERE ((F.PROJECT_ID) IN (SELECT P1.PROJECT_ID FROM T1512369F9074D569E0635904F_TAB P1))OR ((F.ACTIVITY_SEQ_KEY) IN(SELECT A1.ACTIVITY_SEQ FROM S1512369F905BD569E0635904F_TAB A1))OR ((F.ACTIVITY_SEQ_KEY, F.OBJECT_TYPE_KEY, F.KEYREF1_KEY, F.KEYREF2_KEY,F.KEYREF3_KEY, F.KEYREF4_KEY, F.KEYREF5_KEY, F.KE