[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