Re: index hint

Jeroen,

   You need to reference the table in the hint with the alias that you gave it in the from clause (oa), then the hint should work.

Jeroen van Sluisdam wrote:

> > -----Oorspronkelijk bericht-----
> > Van: Jeroen van Sluisdam
> > Verzonden: donderdag 17 januari 2002 14:40
> > Aan: 'ORACLE-L_at_fatcity.com'
> > Onderwerp: index hint
> >
> > Hi,
> >
> > I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working
> > again
> > on same performance after an index has been added in order to get around
> > possible
> > deadlocks because of use of a foreign key relation.
> > I tried adding an hint but this doesn't work, am I making typos?
> > DB is on choose optimizer
> >
> > delete from plan_table;
> > explain plan
> > set statement_id = 'test' for
> > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */
> > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime ,
> > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full ,
> > oa.option_type
> > FROM
> > bedfinder_published_objects bo,
> > option_allotments oa
> > WHERE
> > bo.contract_id = oa.contract_id
> > AND
> > bo.so_id = oa.so_id
> > AND
> > datetime >= trunc(sysdate)
> > ORDER BY 2,3,4,5
> >
> > Tia,
> >
> > Jeroen
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeroen van Sluisdam
> INET: jeroen.van.sluisdam_at_vrijuit.nl

>


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

--
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it"
- Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco_at_ritvax.rit.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).