Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How Materialized Views are linked with Oracle DataWare
house?



How Materialized Views are linked with Oracle DataWare house?..

Answer / 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

More Data Warehouse General Interview Questions

what is the difference between MOLAP and ROLAP?

3 Answers  


what are the all possible features supported modify stage?

0 Answers  


What is MDX?

2 Answers   TCS,


What is data cleaning? How can we do that?

0 Answers  


Explain what is real time data-warehousing?

0 Answers  


ware house management system is used?

0 Answers  


Difference between PowerPlay transformer and power play reports?

0 Answers   CTS,


How to provide security in frame work manager for a query subject?

0 Answers  


Explain what are fact, dimension, and measure?

0 Answers  


Tell me what is degree of a relation?

0 Answers  


How to handle multi value dimensions?

0 Answers  


Define Data Warehousing?

0 Answers   Wipro,


Categories