Skip to Content
avatar image
Former Member

get huge amount of Data with good performance

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 07, 2018 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.

    Add comment
    10|10000 characters needed characters exceeded