Re: Does order of table in from clause matter?

From: HansF <News.Hans_at_telus.net>
Date: Tue, 07 Dec 2004 19:31:48 GMT
Message-Id: <pan.2004.12.07.19.32.09.71658@telus.net>

On Tue, 07 Dec 2004 10:56:24 -0500, Jay wrote:

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

That's one of the primary rules from the old RBO.

If it does matter in your situation, I'd recommend looking whether optimizer is set to chose and CBO is being defeated or stats are wacky.

/Hans Received on Tue Dec 07 2004 - 13:31:48 CST