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
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.