topic Re: which one is better performance between loop and select query. in Application Development and Automation Discussions

which one is better performance between loop and select query.

Former Member — Sat, 04 Mar 2017 17:05:17 GMT

Hi Experts,

I have a question for ABAPER, in my program fetching data from BKPF table based on input fields BELNR, GJAHR and XBLNR. Here XBLNR is a non primary key field, so when data volume is huge system giving dump at BKPF table select query. Anyone can help on this whether i need to create secondary index for BKPF table or I need to fetch data based on BELNR and GJAHR then in loop i will filter by xblnr.

Which one is better performance.

Thanks,

Pradeep.

Re: which one is better performance between loop and select query.

NTeunckens — Mon, 06 Mar 2017 08:51:16 GMT

You should look into creating a secondary index if it is not already in place.

Check with your BASIS-team and perhaps do some tests around this ...

I see a lot of SAP-KBA's with regard to the use of (secondary) indexes on table 'BKPF' in SAP-Standard FunctionModules. So if SAP-Stdrd makes use of it, it is worth checking this out for your own Development as well.

Re: which one is better performance between loop and select query.

RaymondGiuseppi — Mon, 06 Mar 2017 09:50:19 GMT

There is an index with XBLNR but it also require BUKRS and BSTAT. Check with functional if you are able to provide those values too. Also I'm surprised you don't already use BUKRS field.

Re: which one is better performance between loop and select query.

raghug — Mon, 06 Mar 2017 13:13:55 GMT

What am I missing here...

You state that you are getting back so much data with BELNR, GJAHR and XBLNR - that your program dumps on the selection - What is the dump? For volume or time?
Now you want to get rid of XBLNR -> You do realize that will only return more data, right? How is that going to help?

An ABAP loop after bringing all the data over to the application server will never be as efficient as even letting the database server work on un-indexed data. That said, as Raymond said - there is an index - figure out how to use it!

Re: which one is better performance between loop and select query.

Former Member — Mon, 06 Mar 2017 16:24:22 GMT

Use all the three Key fields "BUKRS", BELNR" and "GJAHR" to fetch data from BKPF.