Creating Indexes on Computed Columns

You can use materialized computed columns as index keys, as though they were regular columns.

To convert a virtual column to a materialized column and index it, use alter table modify with the materialized option before executing create index.

A computed column need not be deterministic to be used as an index key; however, you must be careful about the possible impact of a nondeterministic column on the queries that reference it.