Hi All,
I would also like to setup test in QA1(Qualityr) again just like last night. When we ran the job in QA1 it worked much faster and i was able to trap the sql explain in QA1 and I believe it was using the index on the EBAN table. In PRO(production) it is doing a full tablescan which i believe is the root of the problem is not so much the ALE info listed below although it doesn't hurt to go down that path either.
The only difference between QA1 and PRO at this time is the amount of data, QA1.EBAN is only 300+M and PRO is 1.3 GB.
SAP is requisting the explain from both environments?
so if we can get this stepup ASAP that would be great.
waiting for your response ASAP,
Regards,
Subba Reddy