order of tables in FROM ?

From: Phil R Lawrence <prl2_at_lehigh.edu>
Date: 1998/04/29
Message-ID: <6i7nql$163a@fidoii.cc.Lehigh.EDU>#1/1

Hey, anybody can write SQL (I do), but I want to move on to a higher plain.

Is the ordering of tables listed in the FROM statement important for performance?
Is there a FAQ where I can start to learn what things *do* impact performance?

Thanks!

--


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Phil R Lawrence               phone: 610-758-3051
Programmer / Analyst      e-mail: prl2_at_lehigh.edu
194 Lehigh University Computing Center
E.W. Fairchild - Martindale, Bldg. 8B
Bethlehem, PA  18018


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Received on Wed Apr 29 1998 - 00:00:00 CDT