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

问题描述

CTE 还是 Temporary Tables 哪个性能更高?

Which are more performant, CTE or 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

我已将 procs 存储在我同时使用的地方(以及表变量)

I have stored procs where I use both (and table variables too)

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