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
Using the customer, and order table in northwind database, please write a query to produce xml?
What is enhanced database mirroring in sql server 2008?
What are a database and a data warehouse?
What are the different type of replication in sql server?
Explain the difference between control flow and data flow?
What is the osql utility?
What are the types of processing and explain each? : sql server analysis services, ssas
What is service broker? : sql server database administration
What is the federation in sql azure?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What happens when converting big values to integers?
How much memory that we are using in Logshipping Concept?
What are pages and extents? : SQL Server Architecture
What is an etl file?
What is a fill factor?
