GeekInterview.com
Series: Subject: Topic:
Question: 1 of 250

What is the difference between view and materialised view?

Asked by: madhuri_v123 | Member Since Mar-2012 | Asked on: Aug 23rd, 2012

View all questions by madhuri_v123   View all answers by madhuri_v123

Showing Answers 1 - 2 of 2 Answers
manoj100

Answered On : Aug 26th, 2012

View all answers by manoj100

A view is a simple select statement executed each time user runs query against it

A materialized view is a physical persistent object used for performance improvement of summary data or replication. For summary data, when a user queries data against a table / set of tables using join condition with aggregates and group by and if a corresponding materialized view is already created, query_rewrite is enabled, oracle selects the data from the pre-built materialized view enhancing the performance of select query in data warehouse environment. For replication, materialized view is a replica of target master table for replication to other sites and can be fast refresh (changes since the last refreshed), complete refresh or refresh on demand. Materialized view logs are used to keep the changes since the last refresh.

  
Login to rate this answer.
hanuman

Answered On : Sep 4th, 2012

view does not consume space and materialized view consume space

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.