Skip to Content
0
Dec 01, 2005 at 04:52 AM

DB qeury taking too long to execute

21 Views

Hi,

This DB query is taking too long on the customer system!

DB stats checked with DB20. Everything seems okay!

Any Pointer which would lead me to solution are most welcome.

Query is:

"

SELECT DISTINCT * FROM /sapsll/cuhdsta

AS a

INNER JOIN /sapsll/cuhd

AS b

ON amandt EQ bmandt

AND aguid_pobj EQ bguid_cuhd

INTO CORRESPONDING FIELDS OF TABLE lt_cuhd

WHERE a~prost IN lr_prost

AND a~sticm IN lr_sticm

AND a~pobjt EQ gc_pobjr-customs_doc_head.

"

The Table /sapsll/cuhdsta contains about 7 million entries.

Thanks,

Rohit.