Home Forums SQL Server 2005 T-SQL (SS2K5) Common Table Expressions RE: Common Table Expressions
BaldingLoopMan
SSCertifiable
Points: 6378
More actions
December 9, 2009 at 7:23 am
#1089834
Are u saying if i'm using a #table and it has 10,000 recs then the optimizer may not optimize properly? Interesting. Would it by using the CTE w/ 10,000 recs?