sql functions vs sub selects vs inner joins instead of sub selects. Which
is faster."isicoder" <isicoder@.newsgroups.nospam> wrote in message
news:eRs9$YBLGHA.1132@.TK2MSFTNGP10.phx.gbl...
> sql functions vs sub selects vs inner joins instead of sub selects. Which
> is faster.
>
>
Depends on many things. Indexes, parallelism and so forth.
Start doing some reading at www.sql-server-performance.com
Check the execution plans and so forth.
Rick Sawtell
MCT, MCSD, MCDBA
Showing posts with label joins. Show all posts
Showing posts with label joins. Show all posts
Monday, March 26, 2012
Subscribe to:
Posts (Atom)