Computed Columns

Computed columns, computed column indexes, and function-based indexes provide convenient data manipulation and faster data access.

Computed columns and function-based indexes similarly allow you to create indexes on expressions.

Computed columns and function-based indexes differ in some respects:

These are the differences between materialized and not materialized computed columns:
Note: A computed column cannot reference a user-defined function that belongs to a different database.
Related concepts
Deterministic Property
Function-Based Indexes