哪个性能更好，CTE 或临时表?
CTE 或 Temporary Tables 哪个更高效?
推荐答案
我会说它们是不同的概念，但与粉笔和奶酪"没有太大区别.
I'd say they are different concepts but not too different to say "chalk and cheese".
临时表适合重复使用或对一组数据执行多次处理.
A temp table is good for re-use or to perform multiple processing passes on a set of data.
CTE 可用于递归或简单地提高可读性.
并且，像视图或内联表值函数一样，也可以像宏一样在主查询中展开
A CTE can be used either to recurse or to simply improved readability.
And, like a view or inline table valued function can also be treated like a macro to be expanded in the main query
临时表是另一个在范围方面有一些规则的表
A temp table is another table with some rules around scope
我已经存储了我同时使用的过程(和表变量)
I have stored procs where I use both (and table variables too)
相关文章