A materialized view is a derived relation stored in the database, resembles like tables and behaves like indexes. Because of the query intensive nature of data warehousing or online analytical processing applications, ...