Skip to Content
0

Full table scan for CRMD_ORDER_INDEX when calling CRM_ORDER_SAVE

Apr 28, 2017 at 01:14 AM

265

avatar image
Former Member

Hi All,

we are doing some performance testing for CRM order creation, during the performance tunning we found there is a full table scan for CRMD_ORDER_INDEX when the FM CRM_ORDER_SAVE is called. And checked the Indexes delivered by SAP, haven't seen any index can be used to improve the performance - as the selection statement is

Seems this is an issue SAP should consider, is there any standard note can be applied or shall we create an index to CRMD_ORDER_INDEX for field "HEADER" ?

Regards,

Samuel

capture.jpg (193.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Apr 28, 2017 at 04:08 AM
0

Hi Samuel,

I'm not sure if this's the solution, but to get a better understand of the background work, you could enable SQL trace in ST05, normally we can check the execution plan to get a better idea what the program were doing, explicitly what table and fields were used in that SQL statement, and whether it was using full table scan or index scan, then you can decide whether you should create new index or not in SE11, remember not all full table scan are bad.

Regards,

Michael


02.png (63.2 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member
Thank you for your reply, Michael, actually the result of - Full table scan is coming from analysis from ST05, and also from the trace on the database ( Oracle for us ) level, we can see the database had a huge pressure when we creating CRM orders in a bulk ( cause the FM CMR_ORDER_SAVE is called ) - and the table CRMD_ORDER_INDEX for us have more 111 Million.

definitely we need to create an Index, but still don't understand why there is no other customer raised the same issue to SAP.. this should happen to all the sap crm customer...?

Anyway, thanks a lot

0
Raymond Giuseppi
May 02, 2017 at 09:01 AM
0

Did you already read 1527039 - Enhancements in CRM Reporting Framework on 'Major performance problems'.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Raymond, yes, I did check the note - to create an index on a header guid should helpful... however, I am still have the question, why SAP doing select * from CRMD_ORDER_INDEX where HEADER = IT_TABLE-HEARDERS, but no standard index against HEADER created....

possibly need to raise a ticket for this. thanks..

0