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: BOB SHIFLETT Sent: Thursday, September 19, 1996 1:32 PM To: Multiple recipients of list SQR-USERS Subject: table joins or seperate begin-select clause Which is better for machine performance, to join several tables within a single begin-select clause or separate begin-select clauses? Thanx Bob
Unrecognized Data: application/ms-tnef