Re: index hint

Try to use table alias in your hint instead of table name.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 17, 2002 8:45 AM

>
>
> > -----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
> --------------------------------------------------------------------
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

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).