[Oracle] Function based index

Olivier | Tips

Create Function based index : (b-tree)

CREATE INDEX <index_name> ON <table_name> (<function_definition>);

example :

CREATE INDEX fidx_1 ON table_1 (to_char(modifiedon, 'MM-YYYY'));