index hint

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