Interested to Buy Any Domain ? << Click Here >> for more details...
How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6448 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
How to know the time taken for particular report execution?
What is data stream and data adaopter?
Explain what are the advantages and disadvantages of reporting directly against the database?
What are the different types of scd's used in data warehousing?
How can we load the time dimension?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Difference between cold fusion 5 and cold fusion mx 6?
can anybody mail me the FAQS for hyperion essbase amd planning
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Explain functional dependency?
What is the main difference between schema in rdbms and schemas in datawarehouse?
What are Aggregate tables?
What is mean by aggregate aware?
In document how to create metrics?
