Re: Faster outer joins???

I never heard that outer joins will not use any index. From what I see, since you are joining table1 against table2 and the + signs is on table2. So, it should use a row in table1 and compare with table 2 through an index on table 2. Try to force Oracle to use the rule based optimizer by select /*+rule */ ....

I hope that it will force Oracle to use the index on the table which has a + sign

Winnie LIu
poohland_at_hotmail.com

Jose M. wrote in message <35A3E0D3.8312921D_at_arrakis.es>...
>Hi all!
>
>I'm running a query on a table which outer-joins to another table
>
>table 1.field = table2.field (+)
>
>I know it'll be slower that a simple join, but it's too slower for me...
>:-) So I've run the EXPLAIN PLAN utility on that query and what I get is
a
>FULL ACCESS to the second table... but that table has got an index, and
that
>means that it's not being used!!! why??? it would be very faster, because
>that second table is very extense...
>
>Someone told me that outer joins don't use indexes... is that true? or can
I
>do something to improve speed?
>
>Thanx!
>--
>______________________________________________________
>Jose M. Julia' (Seldon_ on IRC) -- Madrid (Spain)
>e-mail: jmjulia_at_arrakis.es
>www: http://www.arrakis.es/~jmjulia
>______________________________________________________
>"Violence is the last refuge of the incompetent"
>("La violencia es el ultimo recurso del incompetente")
> Isaac Asimov
>_____________________________________________________
>
>
Received on Thu Jul 09 1998 - 21:58:51 CDT