Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle not guaranteeing HINT?

Re: Oracle not guaranteeing HINT?

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1998/01/16
Message-ID: <34bfd80d.13649753@www.sigov.si>#1/1

On Fri, 16 Jan 1998 07:52:50 +1030, "Brian L. Modra" <bmodra_at_camtech.net.au> wrote:
>.....[SNIP].....
>SELECT /* INDEX_DESC(tank_readings un_time) */ temperature
>.....[SNIP].....
> SELECT /* INDEX_DESC(...) */ ... FROM ...
>.....[SNIP].....
> SELECT /* INDEX_DESC(...) */ A FROM ...
Just another, non-optimiser hint: be sure to write sintactycaly correct hints if you you don't want to be ignored by Oracle. Don't forget to use "+" as the first character inside your comment text if you want Oracle to interpret comments as hints - as you did in all examples in your posting. Correct syntax would be something like

  SELECT /*+ INDEX_DESC(...) */ ... FROM ...          ^^^
>--
>Brian Modra
>http://www.adelaide.net.au/~bmodra

Regards,


Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================
The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Jan 16 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US