Re: table joins or separate begin-select clause

[Ben Le <ble@ORION.CC.PCC.EDU>]

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