Interested to Buy Any Domain ? << Click Here >> for more details...
How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6651 Views
- Kirloskar, I also Faced
- E-Mail Answers
Answer Posted / satya
Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.
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.
The existence of a materialized view is transparent to SQL,
but when used for query rewrites will improve the
performance of SQL execution. An updatable materialized view
lets you insert, update, and delete.
You can define a materialized view on a base table,
partitioned table or view and you can define indexes on a
materialized view.
A materialized view can be stored in the same database as
its base table(s) or in a different database.
Materialized views stored in the same database as their base
tables can improve query performance through query rewrites.
Query rewrites are particularly useful in a data warehouse
environment.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What is your spectra photometer working principles?
What is the difference between datawarehouse and bi?
What is the use of tabular model, tabular sql, tabular reference in real time application?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is the difference between power center & power mart?
What is pre-emptive and non-pre-emptive?
What is ods (operation data source)?
What are the tools available for etl?
What are aggregate tables and aggregate fact tables?
How can we load the time dimension?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain what is a cube in data warehousing concept?
explain about balanced dimension,
