cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Issue while loading PSA from JCDS table

skmbwconsultant
Discoverer
0 Kudos

Hi,

We have custom delta datasource based UDATE on JCDS table with the safety interval of 2 days. Load were working perfectly fine and brining data in 2 mins.

After that ABAP team created secondary index on JCDS table on following fields,

MANDT

OBJNR

UDATE

UTIME

INACT

After the index available in JCDS table all of sudden dataload started taking 2 hours of time.

Is there any impact of secondary index on source table on BW dataloads.

Best Regards,

Accepted Solutions (0)

Answers (0)