Re: table joins or separate begin-select clause

[pauldp@SFITVA.CC.FITSUNY.EDU]

Could someone from MITI please comment.  It's been a rule here to put the
table which you expect to get the least number of records from last.  It
appears to greatly affect performance when you do that.  If it has
changed (due to Oracle or an SQR upgrade) I'd like to know.  If it
hasn't, a lot of people might be able to enhance performance.

On Wed, 25 Sep 1996, John Douglas wrote:

>     I vote for biggest table last in the From clause.
>
>     John Douglas
>
>     Lockheed Martin
>

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