![]() |
![]() |
![]() |
Calculated Column(s) or a View? When to choose a Calculated Column(s) over a View?
Wayne
Sorry, I forgot to mention that this is for SQL Server 2000.
Wayne
i would prefer view, because calculated column is some view on your table data
IJ
I've come to prefer views over calculated columns. Most of the time, I can tolerate sluggishness on data retrieval (i.e. reporting, etc.), but not on inserts and updates. Any of the calculated columns I've ever used seemed to slow the insert/update by more than I liked.
Ron Porter
|