topic Re: select command on dfkkop in Application Development and Automation Discussions

select command on dfkkop

Former Member — Wed, 12 May 2010 13:17:43 GMT

Hi Forum,

I've just started learning ABAP and thankfull for any help.

When do a selection over the DFKKOP Table by using one of its Indizes (AUGST, VKONT, BUKRS and AUGDT) it still takes 2 Minutes to get results when testing in a real-data-environment.

CODE

select * from dfkkop into table tab_dfkkop

where augst ne 9

and vkont = p_vkont

and bukrs = p_bukrs

and augdt <= sy-datum.

ENDCODE

What can I do to get my code more efficient?

Thanks a lot for your help in advance,

best regards,

beckersk

Re: select command on dfkkop

HermannGahm — Wed, 12 May 2010 13:22:34 GMT

Hi,

please post your execution plan and table and index statistics.

Runtime figures from ST05 (number of records selected, time, ...) would be interesting as well.

Kind regards,

Hermann

Re: select command on dfkkop

Former Member — Wed, 12 May 2010 13:29:15 GMT

Hi Hermann,

thanks a lot for your fast help.

What do you mean with "execution plan and table and index statistics"?

Best regards,

beckersk

Re: select command on dfkkop

Former Member — Wed, 12 May 2010 13:33:14 GMT

The augst ne 9 is probably causing the problem. Change this to augst eq space and see what happens.

Rob

Re: select command on dfkkop

HermannGahm — Wed, 12 May 2010 13:34:32 GMT

Hi,

> What do you mean with "execution plan and table and index statistics"?

all the content you get when you click on "explain" for the statement in the SQL trace.

Here is a little description how and where to get an execution plan generally:

/people/hermann.gahm/blog/2010/03/04/explaining-the-explain-plan

Kind regards,

Hermann

Re: select command on dfkkop

Former Member — Wed, 12 May 2010 13:36:59 GMT


> What do you mean with "execution plan and table and index statistics"?

Moderator message - Welcome to SCN. Unfortunately, this forum is not a place to learn ABAP. I suggest that you get one of the good ABAP books that are out there and maybe join an internet forum that caters to beginners Also please read and before posting Rob

Re: select command on dfkkop

HermannGahm — Wed, 12 May 2010 13:43:06 GMT

Hi Rob,

> "The augst ne 9 is probably causing the problem. Change this to augst eq space and see what happens."

says the experienced developer with application knowledge.

I like those situations where try to apply pure "dumb" technical analysis and methods and then an experienced

developer with application knowledge says something like you did. Often enough they know quick and efficient

changes (e.g. seleting other tables, not selecting tables at all, ...) that are just not "visible" for us technology guys

Kind regards,

Hermann

Re: select command on dfkkop

Former Member — Wed, 12 May 2010 13:50:46 GMT

Hey Rob,

thanks a lot - your "space-tip" worked perfectly. Now the selection needs only 1 -1 2 secs.

Thanks both of you for your help. If I might have posted in a wrong manner or way, I'm sorry and I'll try to obey the rules the next time.

Cheers,

beckersk