How to add an index to a field in a view?

Question

Oracle

How to add an index to a field in a view?
The view has a field that is formed through a function. How to add an index to it?

Answer 1

On a normal view? You can't, emnip. You can create a Materialized View and your indexes are already there - www.sqlsnippets.com/en/topic-12898.html