Interested to Buy Any Domain ? << Click Here >> for more details...
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 options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is an sql server agent?
How to run sql server 2005 books online on your local system?
Explain syntax for disabling triggers?
What is a ddl statement?
What is sql server profiler?
In which sql server version report builder introduced?
What is the report model project?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is dirty page?
What are the differences between char and nchar in ms sql server?
What are commonly used mssql functions in php?
what happens on checkpoint? : Sql server database administration
What purpose does the model database server?
Does the order of columns in update statements matter?
