topic CDHDR table query taking long time in Application Development and Automation Discussions

CDHDR table query taking long time

Former Member — Mon, 30 Jun 2008 08:12:53 GMT

Hi all,

Select query from CDHDR table is taking long time,in where condition i am giving OBJECTCLASS = 'MAT_FULL' udate = sy-datum and langu = 'EN'.

any suggestion to improve the performance.i want to select all the article which got changed on current date

regards

shibu

Re: CDHDR table query taking long time

former_member195383 — Mon, 30 Jun 2008 08:20:50 GMT

Hi..

please make sure that u are not using select * , and are selcting only those fields which are required...That may be one reason of the select query taking longtime..U can paste the select query so that we can get a clearer picture...

Regards

Rudra

Re: CDHDR table query taking long time

ThomasZloch — Mon, 30 Jun 2008 08:26:20 GMT

This will always be slow for large data volumes, since CDHDR is designed for quick access by object ID (in this case material number), not by date.

I'm afraid you would need to introduce a secondary index on OBJECTCLAS and UDATE, if that query is crucial enough to warrant the additional disk space and processing time taken by the new index.

Greetings

Thomas

Re: CDHDR table query taking long time

Former Member — Mon, 30 Jun 2008 08:35:50 GMT

Hello

1. Use your query in LOOP...ENDLOOP with OBJECTID field.

2. Make a secondary index.

Re: CDHDR table query taking long time

alison_lloyd — Tue, 01 Jul 2008 13:13:49 GMT

Have you got a range of objectids you could use?

eg. 0100000000 - 090000000 depending on your matnr range

Re: CDHDR table query taking long time

Former Member — Thu, 03 Jul 2008 10:13:45 GMT

solved.Thanks for all the reply