topic Re: OPEN SQL (SELECT DATA) in Application Development and Automation Discussions

OPEN SQL (SELECT DATA)

Former Member — Fri, 26 Jun 2009 06:23:12 GMT

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 — Fri, 26 Jun 2009 06:40:54 GMT

Some related thread

Former Member — Fri, 26 Jun 2009 06:41:48 GMT

%_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 — Fri, 26 Jun 2009 06:44:14 GMT

Hi,

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