Is there anyone who can share that how can I create index on view & materialized view?
Kindly share your valuable views here.
We can create an index on MV but not on an normal index. This is because, the normal view just holds he select statement. so when we call the view as select * from view name, it is just executing the select statement in the definition.if we really want to improve the performance, we may create the index on the underlying table, which will help in retreiving the data faster.
When you create view on particular table rowid will be the same for both table and view. So it is not possible to create index on view,
Where as in creation of MV rowid is also different for table and materialized view. So we can create index on MV.
Sign up for STechies
Ask Question From Our Experts