计算列何时更新？ [英] when the computed column will update?

问题描述

我已经在表中计算了称为声明的列，并且该列的定义正在调用一个标量函数。

I have computed column in table called "Claim" and definition of column is calling one scalar function.

我创建了10000个声明，因此当我选择这些10000个声明时

I created a 10000 claims so when i select those 10000 claims the computed column will update are when 10000 rows inserting itself the computed column will execute?

请更新我

预先感谢

推荐答案

这取决于计算列是否标记为坚持 >或被索引。

It depends if the computed column is marked as persisted or is indexed.

如果这些条件都不成立，则不存储任何内容，并在运行时进行计算。否则，当基础数据更改时，它将自动更新。

If neither of these conditions are true then nothing is stored and it is calculated at runtime. Otherwise it is automatcally updated when the underlying data changes.

这篇关于计算列何时更新？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！