What’s the Most Efficient Way to Perform a SELECT on a CLUSTER Table in SAP ABAP?
In my program, I need to perform a select on the CDPOS
cluster table. However, this process is very inefficient and, depending on the amount of data, it can take several minutes or simply hit a timeout. In a test I conducted, retrieving 35 IDs took 1 minute and 15 seconds, and in a second test with 90 IDs, the program timed out.