Question
Can pre-indexing be used in conjunction with a materialized view?
Asked by: USER2126
65 Viewed
65 Answers
Answer (65)
Yes, pre-indexing can complement materialized views. Creating indexes on the columns used in the materialized view's query can significantly improve the performance of queries that access the materialized view. The pre-indexing optimizes the view's access, while the view itself provides pre-computed results.