How to Add an Oracle Function Based Index: Unexpected Tips
Oracle function based index enhances the performance with queries that retrieve data using a custom index according to usage. This will improve the performance when consists of function or expression