Re: explain plan

"Michele Campagni" <michele.campagni_at_libero.it> wrote in message news:4413f6c6$0$29103$5fc30a8_at_news.tiscali.it...
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> ha scritto nel messaggio
> news:dut1oh$hpg$1_at_nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...
>> The numbering of the table queues usually indicates
>> the order of generation of virtual tables - but I am
>> a little puzzled by what your query execution plan
>> is showing. Can you post the original query.
>
> Thanks for the answer, The query was a simple "select * from a, b where
> a.key=b.key;" (I think... I don't remember) but it doesn't mind. I was a
> bit confused because I can't find any information about TQ. I hope now I
> can understand a bit more...
>

Thanks for the comment.

I was a little surprised to see the buffer sort and one "extra" table queue in your example. But it looks as if this is a possible consequence of the 'serial to parallel' you have because one of your tables was not parallel-enabled.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html