Skip to Content

get huge amount of Data with good performance

Feb 24 at 10:29 PM


avatar image

Hello once again,

this Time around i need your suggestions for getting huge amount of data with good performance.

The Data that i need to get is stored in the Table DFKKOP on our SAP core system. This system is running on a DB2 database. Our DFKKOP is holding about 1.5 billion of rows.

From a selection before i got about 200.000 Numbers of Business Partners.

Now i have to select all entries in DFKKOP for them. I thought i could eventuelly do this virtually by a virtual table. But when i join DFKKOP with my selection it takes way over one hour to get the results.

We've a Index on Business Partner number on DFKKOP. For testing purposes i use a select on one Business Partner. This takes ließ then an second. For 10 Business Partners it takes more then 5 minutes. This makes no sense to me.

Is it possible that the select it self gets a better performance with a where equal clause than with a where in clause?

Hope that you could possibly help me on this one.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vasily Sukhanov
Mar 07 at 10:16 AM

Hi, i see that "where" predicate with equal clause and filter for 10 records takes about 5 minutes,

Can you use an additional filter like region or location to limit the number of rows where database should scan for matching business partners ?

In case it is possible to have additional filter like location you can make index on both fields - business partner and location and it will speed up the query.

10 |10000 characters needed characters left characters exceeded