To increase performance, materialized views can be created on external table without any additional cost

To increase performance, materialized views can be created on external table without any additional cost
A . TRUE
B. FALSE

View Answer

Answer: B

Explanation:

Materialized views are designed to improve query performance for workloads composed of common, repeated query patterns. However, materializing intermediate results incurs additional costs. As such, before creating any materialized views, you should consider whether the costs are offset by the savings from re-using these results frequently enough.