Computed columns and function-based indexes provide easier data manipulation and faster data access.
Computed columns provide easier data manipulation and faster data access by allowing you to create computed columns, computed column indexes, and function-based indexes.
Computed columns – defined by an expression, whether from regular columns in the same row, functions, arithmetic operators,or path names.
Indexes on computed columns, or computed column indexes – indexes that contain one or more computed columns as index keys.
Function-based indexes – indexes that contain one or more expressions as index keys.
Deterministic property – a property assuring that an expression always returns the same results from a specified set of inputs.
Computed columns and function-based indexes similarly allow you to use an expression or a function as the basis for a more complex function.