Effects of Deterministic Property on Computed Columns

Virtual and materialized are two types of computed columns in SAP ASE.

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.