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
Why do we backup Active Directory ?
Explain the functionalities that views support?
What is report server project?
What samples and sample databases are provided by microsoft?
Ms sql server index?
Can we call stored procedure in view in sql server?
Write a program using SQL queries to find a unique entry in a table.
 Explain what is sql override for a source taLle in a mapping?
What is the difference between for trigger and after trigger?
Can we call future method from trigger?
Do you know the isolation level that sql server support?
What is key set driven?
How would we use distinct statement? What is its use?
Differentiate between truncate vs delete in mssql?
What is ms sql server index?