Hi All,
Does the order of criteria matter in a select or list statement,
or is the execution order arbitrary?
For example, if I wanted to select vendors who sell apples in Denver,
is "Select vendors with location='Denver' and products='Apples'"
the same as "Select vendors with products='Apples' and
location='Denver'"
Given that out of 300 vendors, 50 sell apples, and 100 are in denver,
and 15 of those in Denver sell apples.
If it does matter, should I put the criteria that is likely to return
the smallest result set first?
TIA,
John
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
