Creating a Materialize View and Creating an Index

Immaterialized, the materialize view that we create is an index representation of the data. And then you can issue a query that might use the index as supposed to the base table. Classic seque like optimizations on top of the same data may be in different forms for better access.