topic Re: Using Oracle Hint in Application Development and Automation Discussions

Using Oracle Hint

Former Member — Mon, 11 Sep 2006 18:01:21 GMT

Hi All,

I am trying to force the select query to use an index on a Y table, but some how it is not working. The code i am using is:

SELECT matnr werks vbeln posnr FROM yyost INTO

TABLE tb_yyost1

FOR ALL ENTRIES IN tb_marc WHERE

matnr EQ tb_marc-matnr AND

werks EQ tb_marc-werks AND

auart IN ('TA','KL','SREP','ZDF') AND

clsta EQ 'C' AND

cldat GE dg_fday

%_HINTS ORACLE 'INDEX("YYOST" "YYOST~YYOST__2")'.

Where YYOST is the table and YYOST__2 is the index. Am i missing something? I looked at ST05 and saw that it is still using index YYOST__1.

Regards,

Hari.

Former Member — Mon, 11 Sep 2006 18:17:31 GMT

Hi,

Try this.

%_HINTS ORACLE 'INDEX("&TABLE&" "YYOST~YYOST__2" "YYOST^YYOST__2")'

Thanks,

Naren

Former Member — Mon, 11 Sep 2006 18:18:10 GMT

Hi,

Try this.

%_HINTS ORACLE 'INDEX("&TABLE&" "YYOST~YYOST__2" "YYOST^YYOST__2")'

Thanks,

Naren

Former Member — Mon, 11 Sep 2006 19:17:06 GMT

HI,

you can use inthis way also..

<b>%_HINTS ORACLE 'INDEX(YYOST"YYOST__2")'.</b>

Try this one

Regards

Sudheer