Re: Oracle using indexes

That says:

    Scan tbl2, and for each row access a     system generated unique index (which     will be the index representing the primary     key on tbl1).

I should have realised in my first note that tbl1 would not have been accessed at all to get the results needed by your query.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Christ Follower wrote in message <8821hn$u81$1_at_nnrp1.deja.com>...
>Here you go.
>
>Execution Plan
>----------------------------------------------------------
> 0 SELECT STATEMENT Optimizer=RULE
> 1 0 NESTED LOOPS
> 2 1 TABLE ACCESS (FULL) OF 'TBL2'
> 3 1 INDEX (UNIQUE SCAN) OF 'SYS_C00614077' (UNIQUE)
>
>
>In article <950214257.4952.0.nnrp-03.9e984b29_at_news.demon.co.uk>,
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>>
>> If you have used explain plan
>> why not publish the plan instead
>> of describing one line of the plan.
>>
>> Presumably the query is scanning
>> tbl2 and indexing into tbl1 using
>> the primary key on tbl1.
>>
Received on Fri Feb 11 2000 - 16:27:58 CST