[thelist] [MS SQL Trickery] Is my technique good, bad, or neither?
rudy
rudy937 at rogers.com
Thu Aug 21 13:40:45 CDT 2003
> Why did you pick a CROSS JOIN?
1 coolness factor
2 simplicity
3 no key to join on
4 there's only one row, dude ;o)
> Does a CROSS JOIN run better than an INNER JOIN because
> the parser doesn't worry about having to filter the results?
no idea
it works, that's 90% of what i care about
the other 10% (performance in the real world) i usually delegate to a DBA
run some EXPLAINs, i'd be interested in the comparison
rudy
More information about the thelist
mailing list