Recently I observed that ETL was taking a very long time. Upon analysis I found out that STEP: PLP_APXACTSGROUPACCOUNT_A1_LOAD that was previously completed in 17-18 mins, is been running for 5-6 hrs and there was hardly anything processing happening on data warehouse side.
It seems to happening only in version 184.108.40.206 and 220.127.116.11 and does not have any impact on 7.9.6 or 18.104.22.168
Two indices are required during ETL task PLP_APXACTSGROUPACCOUNT_A1_
LOAD that are marked as ‘Query’ rather than ‘ETL’, and are therefore dropped in DAC before the task runs. This affects performance. DAC metadata needs to be changed to mark them as ETL indices.
Objects : Indices W_AP_XCT_GAD_D_F11 and W_AP_XCT_GAD_D_F6.
Modification: Change the Index Usage for these indices from