Re: Can a Query fill the system?

I think what Kent might have meant is dependant on how you do the join.
If you use a WHERE clause join,  The system will decide which is first.
But if you use the  JOIN clause I don't think it second guess's  you. (I
think all Query/400 joins are WHERE clause joins off the top of my head).

I may be wrong on that if it has changed in a very recent release.    I
probably will be corrected shortly if I am incorrect.

John
------------------------------------------------
Dale-

I was always under the impression that you should specify the file with the
least number of records FIRST in the join specifications.

However, I recently saw a post by Kent Milligan (DB2/400 guru at IBM) on
comp.sys.ibm.as400.misc that indicates the query optimizer will take care
of
this for you, so it doesn't matter which file you specify first.