Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
>> To REMOVE yourself from this mailing list, send an E-Mail message
> 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).Received on Thu Jan 17 2002 - 08:26:43 CST
![]() |
![]() |