 Expression index

An expression index, also known as a function based index, is a database index that is built on a generic expression, rather than one or more columns.This allows indexes to be defined for common query conditions that depend on data in a table, but are not actually stored in that table.