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

I need a good brd and uc template?

587


Explain which columns go to the fact table and which columns go the dimension table?

521


Explain why fact table is in normal form?

539


Explain what are the different types of join operations?

538


What are diagrams?

621






What is surrogate key? Explain with examples.

608


Explain how to get the first 100 rows from the flat file into the target?

524


Explain about core dimension,

539


What are components of report studio?

537


How to generate iqd file from framework manager?

526


Explain me what is vldb?

522


What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

535


Explain what are the different methods of loading dimension tables?

509


What is the use of tabular model, tabular sql, tabular reference in real time application?

520


Explain what is the difference between powerplay transformer and power play reports?

642