哪个性能更好，CTE 或临时表? [英] Which are more performant, CTE or temporary tables?

问题描述

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)

这篇关于哪个性能更好，CTE 或临时表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！