when the computed column will update?

Question

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

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?

Please update me

Thanks in advance

Is the computed column marked as `persisted` or not? – Martin Smith Mar 16 '11 at 16:11 — Martin Smith, Mar 16 '11 at 16:11

score 7 · Accepted Answer · answered Mar 16 '11 at 16:14

7

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.

answered Mar 16 '11 at 16:14

Martin Smith

438,706
87
741
845

Brian Driscoll · Answer 2 · 2011-03-16T20:39:51.007

1

The computed column computes its value when you execute a SELECT command that includes the column, assuming that the computed column's value is not PERSISTED.

edited Mar 16 '11 at 20:39

answered Mar 16 '11 at 16:04

Brian Driscoll

19,373
3
46
65

when the computed column will update?

2 Answers2

Linked