Oracle function based index enhances the performance with queries that retrieve data using a custom index according to usage.