Organizational Research By

Surprising Reserch Topic

boostr.in questions - Question:Which of the following statements are true regarding materialized views?


a.        Materialized views cannot be partitioned, nor can they be defined on partitioned tables
b.        Materialized views are often used in data warehouses to increase the speed of queries on very large datatables
c.        Queries that benefit from the use of materialized views often involve joins between tables or aggregations such as SUM
d.        A materialized view stores both the definition of a view and the rows resulting from the execution of the views
e.        Materialized views can be used to replicate data, which was formerly achieved using the CREATE SNAPSHOT statement
asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
10 views



Related Hot Questions



Government Jobs Opening


...