Answer Posted / lekhrajdeshmukh
**A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.
**You can define a materialized view on a base table,
partitioned table or view and you can define indexes on a
materialized view.
**Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do indexes help, types?
How to download and install microsoft .net framework version 2.0?
What are the new security features added in sql server 2012? : sql server security
What is factless fact table? : sql server analysis services, ssas
How to execute multiple stored procedures at one time in sql server?
Explain different types of locks in sql server.
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Name and describe few console utilities for ssrs?
What are data files?
what is create database syntax? : Sql server database administration
What are views used for?
Why we use the openxml clause?
How to make conditional sum in ssrs?
what are acid properties? : Sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
