Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stan Kulp Simplify Large Queries with Temporary Tables, Table Variables and CTEs RE: Simplify Large Queries with Temporary Tables, Table Variables and CTEs
Stan Kulp-439977
SSChampion
Points: 10062
More actions
August 9, 2011 at 10:03 pm
#1366389
From my experience, a temporary table is the only way to go with that many records.
A table variable or CTE would be way too slow.