OPEN SQL (SELECT DATA)

[Former Member]

Hi, everybody!

Recent i found a few code but i don't know this mean of code. fllows as.

SELECT B_{MATNR B}WERKS E~MTARP AS MTART

C_{SPART D}MAKTX

APPENDING CORRESPONDING FIELDS

OF TABLE LT_PMAT

FROM STPO AS A

INNER JOIN MAST AS B

ON B_{STLNR = A}STLNR

INNER JOIN MARA AS C

ON C_{MATNR = B}MATNR

INNER JOIN MARC AS E

ON E_{MATNR = B}MATNR

AND E_{WERKS = B}WERKS

LEFT OUTER JOIN MAKT AS D

ON D_{MATNR = B}MATNR

AND D~SPRAS = C_E

FOR ALL ENTRIES IN LT_CMAT

WHERE A~STLTY EQ C_M "Material Bom

AND A~IDNRK EQ LT_CMAT-MATNR

AND B~WERKS IN R_WERKS

AND B~STLAN IN R_STLAN

AND B~STLAL IN R_STLAL

%_HINTS ORACLE

'LEADING(T_00) USE_NL(T_00 T_01 T_02 T_03 T_04)'.

look bold-face!

I don't know what is "%" and code of last-line !

Please help me!

Thanks Advanced!

[former_member222860]

Some related thread

[Former Member]

%_HINTS ORACLE means you are giving hints/instructions to oracle database, for the sole purpose of database optimization.

The DB optimizer follows certain rules to decided use of index, buffer etc. %_HINTS overrides it by giving specific instruction to oracle.

See OSS Note 129385 for furthur information on using %_HINTS

[Former Member]

Hi,

Using HINT means we are forcing the database table to follow the specified path..