Skip to Content

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

Inner Join. How to improve the performance of inner join query

Inner Join. How to improve the performance of inner join query.

Query is :

select f1~ablbelnr

f1~gernr

f1~equnr

f1~zwnummer

f1~adat

f1~atim

f1~v_zwstand

f1~n_zwstand

f1~aktiv

f1~adatsoll

f1~pruefzahl

f1~ablstat

f1~pruefpkt

f1~popcode

f1~erdat

f1~istablart

f2~anlage

f2~ablesgr

f2~abrdats

f2~ableinh

from eabl as f1

inner join eablg as f2

on f1ablbelnr = f2ablbelnr

into corresponding fields of table it_list

where f1~ablstat in s_mrstat

%_HINTS ORACLE 'USE_NL (T_00 T_01) index(T_01 "EABLG~0")'.

I wanted to modify the query, since its taking lot of time to load the data.

Please suggest : -


Treat this is very urgent.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question