Michael,
>Assuming that there's a WHERE clause that makes you get all leftside records
>anyway--none will be excluded--would one JOIN perform better than the other? I'm
>just wondering if there's a performance advantage for one over the other and
>thought some SQL guru out there might know...
Since the WHERE clause is evaluated after the JOINs are complete, if
the WHERE isn't optimizable, or there are many more records in the
JOIN product than the final result, it's my understanding that that
the JOIN will be faster than the WHERE. However, IANASG, so I'll be
interested to read responses to your thread.
Regards-
Nancy Folsom
Pixel Dust Industries
Author _Debugging_Visual_FoxPro_Applications_
http://www.hentzenwerke.com/catalogpricelists/debugvfp.htm
©2004 Nancy Folsom |
