Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle not guaranteeing HINT?
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