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
What is a derived table?
What is dbcc command in sql server?
What is explicit mode in sql server?
What is a View ? Can we insert, Update and delete a view?
What are the different Topologies in which Replication can be configured?
How to see the event list of an existing trigger using sys.trigger_events?
What are distributed partitioned views?
Explain primary key?
What is 2nf in normalization?
What is the ‘fillfactor’?
Where are sql server user names and passwords stored in sql server?
List out a number of the wants to setup a SQL Server failover cluster?
Can another user execute your local temporary stored procedures?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
what are the different types of replication you can set up in sql server? : Sql server database administration
