SQL Server：非持久计算列与视图的好处(SQL Server: Benefit of a non

SQL Server：非持久计算列与视图的好处(SQL Server: Benefit of a non-persisted computed column vs views)

我可以理解persisted计算列的好处：总是可以产生相同结果的计算也可以在插入/更新时缓存，以便以后节省时间和精力。

是否有非持久计算列的特殊好处？ 与保存视图不一样吗？

I can understand the benefits of a persisted computed column: calculations which will always yield the same results might as well be cached on insert/update to save time and effort later.

Is there a special benefit of a non-persistent calculated column? Isn’t that the same as saving a view?

最满意答案

是否有非持久计算列的特殊好处？

与持续计算的列相比，它可以节省存储空间，并且仍然可以编入索引。 与一个视图相比，它可以避免您拥有一个单独的对象进行管理。

但是没有一种计算列被广泛使用。

大卫

Is there a special benefit of a non-persistent calculated column?

vs. a persisted calculated column it saves on storage and can still be indexed. vs. a view it saves you from having a separate object to manage.

But neither kind of calculated columns are used extensively.

David