There are two types of computed columns in Adaptive Server:
Virtual computed columns
Materialized computed columns
A virtual computed column is referenced by a query, and is evaluated each time a query accesses it.
A materialized computed column’s result is stored in the table when a data row is inserted, or when any base columns are updated. When a materialized computed column is referenced in a query, it is not reevaluated. Its preevaluated result is used.
A nonmaterialized, or virtual, computed column becomes a materialized computed column if it is used as an index key.
A materialized computed column is reevaluated only if one of its base columns is updated.
