New Features in Release 22.3

Indexing Functions in SQL

Indexes can now be created on the values of one or more functions over index paths. The set of functions that support indexes is the following subset of the builtin functions:

modification_time, expiration_time, expiration_time_millis, row_storage_size, year, month, day, hour, minute, second, millisecond, microsecond, nanosecond, week, length, replace, reverse, substring, trim, ltrim, rtrim, lower, upper.