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 is the difference between openrowset and openquery?
Explain something about security and SQL Azure?
How will you go about resolving deadlocks?
Explain different types of Normalization.
what is unique and xaml nonclustered index
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is SQL Azure Federations?
What is checkpoint process in the sql server?
How to copy the tables, schema and views from one sql server to another?
Do you have any idea about the tcl commands?
What are the restrictions applicable while creating views? : SQL Server Architecture
Why truncate is ddl command?
What is the difference between coalesce() & isnull()?
what is a schema in sql server 2005? : Sql server database administration
Explain “row_number()” in sql server with an example?
