Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the difference between view and materialized view?

Warehousing
user-image
Question added by ALI ABDULLAH HASAN AL-KHAFAJI , Warehouse & Logistics Manager , Earth link Telecom
Date Posted: 2014/06/15
Upvote (0) Views (1) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Aman uddin
by Aman uddin , Duty Manager , Smyths Toys Stores

. Materialized views are disk based and update periodically base upon the query definition.Views are virtual only and run the query definition each time they are accessed. Views evaluate the data in the tables underlying the view definition at the time the view is queried.

Write Your Answer
More Questions Like This