topic Re: Performance issue in CDHDR & CDPOS in Application Development and Automation Discussions

Performance issue in CDHDR & CDPOS

Former Member — Fri, 10 Jun 2011 14:37:21 GMT

Hi,

I'm having the below QUERY on CDHDR which take a <bowdlerized> lot of time:

SELECT OBJECTCLAS

OBJECTID

CHANGENR

TCODE

UDATE

UTIME

INTO TABLE IT_CDHDR2

FROM CDHDR

WHERE OBJECTCLAS = C_OBJECT

AND OBJECTID = C_OBJECT

AND ( TCODE = C_TCODE1 OR

TCODE = C_TCODE2 ).

Then I've the other select query on CDPOS using for all entries on IT_CDHDR2. Both the queries are taking a lot of time.in the CDPOS select query I'm passing all the keys in order while I couldn't do that for CDHDR. Kindly advise if anyone has worked on the performance issues with CDHDR/CDPOS. What are all the possible ways of improving the performance of CDHDR / CDPOS.

Thanks:

Gaurav

Edited by: Rob Burbank on Jun 10, 2011 3:00 PM

Re: Performance issue in CDHDR & CDPOS

Former Member — Fri, 10 Jun 2011 14:50:36 GMT

Ask your DBAs when was the last time that they ran "stats" on CDHDR and CDPOS.

Running stats optimizes performance when accessing a table.

Re: Performance issue in CDHDR & CDPOS

yuri_ziryukin — Fri, 10 Jun 2011 16:02:34 GMT

Hello Gaurav,

basically John was right.

Table CDHDR has first key fields MANDT, OBJECTCLAS, OBJECTID.

Object ID is normally selective enough to provide good performance for the select that you mentioned.

The only reason that comes to my mind is the outdated statistics.

When the database decides whether to make an index scan or a full table scan, it looks at the table statistics (number of rows, selectivity, etc.). Tables like CDHDR grow after GoLive of the system. If the statistics was last collected when this table was small, the database will think that it will be cheaper to do a full table scan. And it is not the case anymore.

Please go to the transaction DB20 and update statistics for CDHDR and CDPOS tables.

See if it helps.

Regards,

Yuri

Re: Performance issue in CDHDR & CDPOS

Former Member — Fri, 10 Jun 2011 17:11:21 GMT

Hi John/Yuri,

I'll just check on that & update you on this. Thanks for your response.

Thanks:

Gaurav

Re: Performance issue in CDHDR & CDPOS

former_member206439 — Fri, 10 Jun 2011 18:21:40 GMT

Hi Gaurav,

Please check the FM - CHANGEDOCUMENT_READ_HEADERS

You can read the document of this FM also.

For CDPOS

The FM - CHANGEDOCUMENT_READ_POSITIONS

Read the documenatation.

It may help the performance.

Re: Performance issue in CDHDR & CDPOS

eduardo_hinojosa — Tue, 14 Jun 2011 10:22:27 GMT

See the report RSSCD100. It isn't slow. It will give ideas how to solve it.

Regards

Eduardo

Re: Performance issue in CDHDR & CDPOS

Former Member — Wed, 29 Jun 2011 19:51:47 GMT

Hi,

Try Naresh Nelapatla's answer. I had same issue some time back and tried those FM and performance was good compared to direct fetch.

Thanks,

Jagadish

Re: Performance issue in CDHDR & CDPOS

murtuza_chhatariya — Fri, 29 Jul 2011 10:25:51 GMT

Please check below thread

[;