Re: SQL(embedded or not) and OPNQRYF

----- Original Message -----
From: "Carel Teijgeler" <teygeler@bart.nl>
> > Does SQL and/or OpnQryF filter records before the joining of 2 files?
> To my knowledge, any query using the query engine will first join the
file, then
> check the selection criteria and lastly, return the selected fields.

If Query processes joined files the same way as SQL and OpnQryF, then you
are not correct.  Here is what they say in Appendix C of the Query/400
manual:

"Query runs more efficiently when the files are ordered from smallest to
largest.  In this case, smallest means the file from which the fewest
records are selected for the join.  Although this can be the file with the
least records, in some cases a very large file can be used if only a few
records are chosen from that file. "

I interpret this as the selection occurring before the join.

Bill




_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---