Interested to Buy Any Domain ? << Click Here >> for more details...
How can Oracle Materialized Views be used to speed up data
warehouse queries?
- 3 Answers
- 13424 Views
- I also Faced
- E-Mail Answers
Answer Posted / sabeena
A materialized view is a database object that contains the
results of a query. They are local copies of data located
remotely, or are used to create summary tables based on
aggregations of a table's data. Materialized views, which
store data based on remote tables are also, know as
snapshots.
A materialized view can query tables, views, and other
materialized views. Collectively these are called master
tables (a replication term) or detail tables (a data
warehouse term).
For data warehousing purposes, the materialized views
commonly created are aggregate views, single-table
aggregate views, and join views.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What is a functional dependency f said to be minimal?
Explain difference between data ware house & data mart?
what is user variable in affinium campaign? and some real time examples.
what are the others of "bad files" and "discard files" when using sql*loader?
What are the difference between snow flake and star schema?
Explain swot analysis?
What is the function of etl when used in data warehousing?
What is difference between model & package?
Difference between cold fusion 5 and cold fusion mx 6?
Explain what is the data type of the surrogate key?
Where the applications and where ware house management system is used?
What is data validation strategies for data mart v?
Explain what is cost benefit analysis (cba)?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
