Hi guru's, I have a problem with a BW system. I see in SM66 that accessing the table RSBATCHDATA takes a very long time and involves sequential reads. With transaction SM50 I can see that the table is queried with the following command:
SELECT "BATCH_ID" , "TIMESTA FROM "RSBATCHDATA" WHERE "RELID" = :A0#
The funny thing is that this table has the following key:
RELID BATCH_ID BATCH_PROCESS METHOD TIMESTAMP SRTF2
Therefore I would expect that access to this table should be very fast. Nevertheless, the system that I work with shows me 1205 seconds (and still counting while I write this) and "Sequential read".
Can someone explain this to me? Furthermore: is there a whitepaper about the detailed screen that you see when you double-click a line in SM50.