Re: table joins or separate begin-select clause

[pauldp@SFITVA.CC.FITSUNY.EDU]

I believe it is just the opposite.  The table which you expect to
retrieve the least number of rows from is the one that should be listed last
in the from clause.

On Fri, 20 Sep 1996, Ben Le wrote:

> At 03:33 PM 9/19/96 -0400, you wrote:
> >I would say it depends on the number of tables and their data distribution.
> I have had 6 table joins work wonderfully, while 4 table joins are slow.  I
> think in general it is better to put as many tables in the main join as make
> sense to have the initial select return the most important rows.  I try to
> structure selects to do as few I/O operations as possible.  The less server
> I/O and LAN packets the better.
> >
> >Hope this helps some.
> >
> >Brent
> >btempleton@pmai.org
> >
> >
> From my experience when you join many table together, you need to put the
> bigest table at last on line FROM .... to improve the perfomance.
> Ben.
>
>
> --------------------------------------------------------------------
> Ben Le                                  Direct/Voice: (503)-977-4970
> Portland Community College, ITS         Fax: (503)-977-4987
> PO Box 19000 Portland, OR. 97280-0990   Internet: ble@pcc.edu
> --------------------------------------------------------------------
>

Diane Paul
Fashion Institute of Technology
INTERNET ADDRESS PAULDP@SFITVA.CC.FITSUNY.EDU
212-760-7854