Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
>Hi Fabio,
>
>I did not test speed here. I see what you're doing here though, trying to use rushmore to let the db engine to come to to the conclusion earlier that there is no match. It is somewhat a pitty that the DB engine is not able to determine that in the first place by using a constant like .F.
>
>Walter,
>
I Agree.
VFP Engine cut a WHERE .F. or a INNER JOIN ON .F.
But LEFT/RIGHT/FULL JOIN are executed with a CARTESIAN product !!
Fabio
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only