Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Does order of table in from clause matter?

Does order of table in from clause matter?

From: Jay <no_at_spam.com>
Date: Tue, 7 Dec 2004 10:56:24 -0500
Message-ID: <cp4jjg$1rr2$1@msunews.cl.msu.edu>

I have queries with half dozen tables joining each other. I never thought order of tables in from clause is matter. However, when I change order around CBO is same but speed is definitely different.
Does order of table in from clause matter?

Thanks.

-- 
****************** End of Message ******************
Received on Tue Dec 07 2004 - 09:56:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US