select on CDHDR time taking

[Former Member]

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

[Former Member]

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

[Former Member]

hi,

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

Thanks,

Kasiraman R

[Former Member]

hi,

sorry they are all tables. (ranges)

[Former Member]

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

[Former Member]

hi

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^

[Former Member]

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

[Former Member]

No

INTO CORRESPONDING FIELDS does not make any considerable difference.

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

[Former Member]

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.