Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance issue on select query

hi,

Can any explain how the system behaves for the below 2 scenarios and which is much better?

In table EABLG i have around 1 billion records (FYI)

1)

SELECT

ablbelnr

anlage

ablesgr

FROM eablg

INTO TABLE it_eablg

FOR ALL ENTRIES IN it_eanl

WHERE ( anlage = it_eanl-anlage

AND ablesgr = '01'

AND adatsoll GT '20080706' ) " last 3 months

OR ( anlage = it_eanl-anlage

AND ablesgr = '06'

AND adatsoll GT '20080706' ) " last 3 months

2)

SELECT

ablbelnr

anlage

ablesgr

FROM eablg

INTO TABLE it_eablg

FOR ALL ENTRIES IN it_eanl

WHERE anlage = it_eanl-anlage

AND ( ablesgr = '01'

OR ablesgr = '06')

AND adatsoll GT '20080706' . " last 3 months

thanks in advance.

with regards

sumanth

.

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question