Skip to Content

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

wht is the purpose of using oracle hints on BSEG & BKPF tables?.

Hi,

wht is the difference between writing a query using/with-out using %_HINTS ORACLE on BSEG & BKPF tables.

Is there any performance issue if we write the queries using hints.

Please see the below queries.

SELECT bukrs

belnr

gjahr

FROM bkpf INTO TABLE i_bkpf

WHERE AND bukrs EQ p_bukrs

AND gjahr EQ p_gjahr

AND monat EQ p_monat

AND blart IN s_blart

AND stgrd EQ ''

%_HINTS ORACLE

'INDEX("T_00" "BKPF~0" "BKPF^0" "BKPF______0" "BKPF______0__X")'.

SELECT bukrs

belnr

gjahr

FROM bseg INTO TABLE i_bseg

WHERE bukrs EQ i_bkpf-bukrs

%_HINTS ORACLE

'INDEX("T_00" "BSEG~0" "BSEG^0" "BSEG______0" "BSEG______0__X")'.

Regards,

vinod

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