what is Materialized Views?

Answer Posted / vr

A materialized view is a database object that contains the results of a query. For example, it may be a local copy of data located remotely, or may be a subset of the rows and/or columns of a table or join result, or may be a summary based on aggregations of a table's data.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are fact, dimension, and measure?

545


Explain vldb?

621


Database in use is oracle?

593


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

504


What is surrogate key? Explain with examples.

599






What are the difference between snow flake and star schema?

505


Start a batches with in a batch?

547


Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

582


Code the tables statement for a single-level (most common) frequency?

464


What are situations where snow flake schema is better than star schema to use and when the opposite is true?

526


What is factless fact tables?

630


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

1884


For faster process, what we will do with the universe?

564


Explain what are the possible data marts in retail sales?

498


How do we design a universe?

516