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 does this statement do @@rowcount?
What is snapshot report?
What is merge replication?
What is meant by referential integrity?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is the recommended total size of your memory optimized tables?
tell me the disaster recovery plan
What are 3 ways to get a count of the number of records in a table?
Where are sql server usernames and passwords stored in the sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is an indexing technique?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is the difference between for xml raw and for xml auto?
Explain the functionalities that views support?
Can binary strings be used in arithmetical operations?
