topic Re: select on CDHDR time taking in Application Development and Automation Discussions

select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 11:21:25 GMT

hello all,

I have below statement ( copied from FM SD_CHANGE_DOCS_LOAD)

SELECT * INTO TABLE i_cdhdr FROM cdhdr "Read changedoc header

WHERE objectclas = chgdoc-class

AND username IN so_user

AND udate IN so_date

AND utime IN so_time

AND tcode IN so_tcode.

It is taking too much time which is unacceptable.

do you have any idea to improve the efficiency in the above

useful answers will be rewarded.

thanks

Can you please suggest

Re: select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 11:28:48 GMT

hi,

try replacing IN operator by = sign in case so_* are not tables.

Thanks,

Kasiraman R

Re: select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 11:32:30 GMT

hi,

sorry they are all tables. (ranges)

Re: select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 11:36:09 GMT

Hi,

Try reducing the number of columns . instead of select * use only selected columns.

There is no other way to improve the performance of this query.

Thanks,

kasiraman R

Re: select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 11:45:14 GMT

good

try to use the MOVE CORREPOSDING FIELDS OF statement with the select query and see the difference,try to use the key field in the select query.

thanks

mrutyun^

Re: select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 11:56:04 GMT

Hi Kasi,

there are not many fields in the table

Hi Mruthyun,

do mean to say INTO CORRESPONDING FIELDS OF ?

I was thinking avoiding this is better.

ok, let me try that too

Re: select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 12:08:32 GMT

INTO CORRESPONDING FIELDS does not make any considerable difference.

I can not give all the key fields because I will be knowing only OBJECTCLASS.

Re: select on CDHDR time taking

Former Member — Tue, 18 Dec 2007 12:26:48 GMT

Hi Surendra,

performance of the select statement might be low bcoz of the selection strategy you followed while coding the select statement. i think this link might help u to solve ur problem upto some extent

http://help.sap.com/saphelp_47x200/helpdata/en/69/c250684ba111d189750000e8322d00/frameset.htm

Thanks,

anil.