Expensive SQL statements & no proper indexing INCLUDE LPSSTU03-PSST FuncGrp

[Former Member]

Hi there forum

During a recent upgrade we have implemented EhP4 with relevant Support Packs.

Our Early Watch Report nows highlights INCLUDE LPSSTU03 in Function Module Group PSST as having expensive SQL statements along with improper indexing.

Although I have seached through OSS and Forums I can find nothing of help.

Is there an EXPERT out there who can help because SAP tells me that is the way it works!

Thanks.

Carl Cavendish-Davies

[Former Member]

Herewith the latest results from the Early Watch report on this issue:

Object Type Total Executions Disk Reads Elapsed Time Buffer Gets Records Processed

TABLE 242481 1873373 12035981 36237218 34390383

SELECT

"MANDT" , "OBJNR" , "STAT" , "CHGNR" , "USNAM" , "UDATE" , "UTIME" , "TCODE" , "CDTCODE" , "INACT" , "CHIND"

FROM

"JCDS"

WHERE

"MANDT" = :A0 AND "OBJNR" IN ( :A1 , :A2 , :A3 , :A4 , :A5 )&

Execution Plan

V$SQL_PLAN addr= C000000774FF4038 hash= 3408408745 sql_id 4w93fuv5khc59

SELECT STATEMENT Estimated Costs= 6 Estimated Rows= 0 Optimizer: ALL_ROWS

3 INLIST ITERATOR

2 TABLE ACCESS BY INDEX ROWID JCDS

Estimated Costs= 5 Estimated Rows= 28 Estim. Bytes: 1,848

Estim. CPU-Costs = 41,426 Estim. IO-Costs = 5

1 INDEX RANGE SCAN JCDS~0

Estimated Costs= 1 Estimated Rows= 28 Access predicates:

"MANDT"=:A0 AND (("OBJNR"=:A1 OR "OBJNR"=:A2 OR "OBJNR"=:A3 OR "OBJNR"=:A4

OR "OBJNR"=:A5)) Search Columns: 2 Estim. CPU-Costs = 6,777 Estim. IO-Costs = 1

Program Data:

Origin of ABAP coding

Program Name Line Created By Last Changed By Last Changed On

LPSSTU03 44 SAP SAP 25.03.2003

000044 SELECT * FROM JCDS

000045 APPENDING CORRESPONDING FIELDS OF TABLE T_JCDS

000046 FOR ALL ENTRIES IN R_OBJNR

000047 WHERE OBJNR = R_OBJNR-OBJNR.