As mentioned materialized views can be used to access remote database tables across database links or can be used to store computed, complex queries within the same database. A practical use of materialized views will be in an operational data store or data warehouse.
You can create indexes on materialized views as well.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.