Skip to Content
0
Former Member
Mar 13, 2008 at 07:06 PM

Oracle hint needed for a select statement

557 Views

Hi,

The index of table was changed so I had readjust my SELECT statement . Now I needed to write a ORACLE hint for this new index .

How do write a hint ? Please advise . I have never written an hint before .

My select statement is as below and table is MDRS

SELECT * FROM MDRS

INTO TABLE ITAB_MDRS

FOR ALL ENTRIES IN ZMATERIAL

WHERE MATNR = ZMATERIAL-MATNR

AND XLOEK = X_XLOEK

AND KZEAR = X_KZEAR

AND WERKS IN WERKS_RANGE

AND BDART IN BDART_RANGE.

Thanks

Teresa