loading data from R3 46C system hang view COVP

[nicola_blasi]

Good morning

During a loading in a BW systema from a R3 46c , the query hang in R3 in view COVP.

The tables of this view are COEP and COBK and it seems that they bring the correct index...

SQL Statement

SELECT

"BEKNZ" , "BELNR" , "BELTP" , "BLART" , "BLDAT" , "BUDAT" , "BUKRS" , "BUZEI" , "EBELN" ,

"EBELP" , "FKBER" , "GJAHR" , "GKOAR" , "GKONT" , "GSBER" , "KOKRS" , "KSTAR" , "KWAER" ,

"MATNR" , "MBFBTR" , "MBGBTR" , "MEFBTR" , "MEGBTR" , "MEINB" , "MEINH" , "OBJNR" , "OBJNR_N1" ,

"OWAER" , "PAROB1" , "PBUKRS" , "PERIO" , "PERNR" , "PFKBER" , "QMNUM" , "REFBK" , "REFBN" ,

"REFBT" , "REFBZ" , "REFGJ" , "SGTXT" , "TWAER" , "USNAM" , "VERSN" , "VRGNG" , "WERKS" ,

"WKFBTR" , "WKGBTR" , "WOGBTR" , "WRTTP" , "WTGBTR"

FROM

"COVP"

WHERE

"LEDNR" = :A0 AND "OBJNR" BETWEEN :A1 AND :A2 AND "GJAHR" BETWEEN :A3 AND :A4 AND "WRTTP" IN (

:A5 , :A6 , :A7 ) AND "BUDAT" BETWEEN :A8 AND :A9 AND "TIMESTMP" BETWEEN :A10 AND :A11 AND

"MANDT" = :A12#

Execution Plan

SELECT STATEMENT ( Estimated Costs = 1.297 , Estimated #Rows = 1 )

5 FILTER

5 NESTED LOOPS

5 TABLE ACCESS BY INDEX ROWID COEP

INDEX RANGE SCAN COEP~4

5 TABLE ACCESS BY INDEX ROWID COBK

INDEX UNIQUE SCAN COBK~0

The index used are the following:

COEP~4

MANDT 1

TIMESTMP 1.378.785

OBJNR 103.840

COBK~0

MANDT 1

KOKRS 10

BELNR 45.534.688

Have you some idea to do a better performance of this query?

in the meanwhile i'm running the statistics of these two tables , but i don't think this is the problem....

thanks

Nick

[nicola_blasi]

ok

[former_member204746]

Maybe not the best answer, but it should do the trick, even if it can be considered as an overkill.

create an index with these fields:

MANDT

LEDNR

OBJNR

GJAHR

WRTTP

BUDAT

TIMESTMP