on 02-24-2018 10:29 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.