You have analyzed your client’s workload and the Materialized Views Advisor in Enterprise Manager recommends that you create some materialized views to improve performance. What should you do in order to most simply implement this change?
A. Rewrite all the queries in the application to identify materialized view
B. Rewrite existing queries. New queries will automatically use the views.
C. Respond positively to the Advisor to create the materialized views.
D. Build virtual views on a third normal form schema.