Re: SQL Optimisation , FROM Clause table order, Where clause etc

From: <jtesta_at_my-dejanews.com>
Date: Tue, 04 Aug 1998 14:45:41 GMT
Message-ID: <6q76ql$fii$1@nnrp1.dejanews.com>

MY first question would be have you tried it?????. there is nothing like experimentation to find out something.

In article <6q6c62$kf4$1_at_news.mel.aone.net.au>, "Rodger Talevski" <Talevski.Rodger_at_cabs.com.au> wrote:
> Hi All
>
> I'm trying to find out if the order of the tables listed in the from clause
> will affect performance when querying from more than one table. Also should
> the Where clause start with expressions from larger tables etc.
>
> EG TABLE A 10000 Rows TABLE B 5000 rows TABLE C 100 rows
>
> SELECT A.COL1, B.COL etc etc
> FROM A, B,C
> WHERE A.COL1 = B.COL1 AND
> A.COL2 = B.COL2 AND
> B.COL4 = C.COL3
>
> I want to know if
> 1. the FROM clause table order will affect performance and
> 2. the where clause works in a similar fashion
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 04 1998 - 09:45:41 CDT