When is a functional index used?

The optimizer considers whether to use a functional index to access the results of functions that are in a SELECT clause or are in the filters in the WHERE clause.


Copyright© 2019 HCL Technologies Limited