Difference between view and materialized view

This video is a free tutorial on the difference between views and materialized views. The tutorial demonstrates the difference between oracle pl/sql view and an MV through a detailed explanation of sections such as data storage, refresh option, query tuning option and performance benchmark.

By learning the difference the users can make an effective judgment on when to use view and when to use a materialized view.

Video on Views:    • WHAT ARE VIEWS IN DATABASE??  
Video on MV:    • Materialized Views in Oracle ( Part -...  

If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below:

procedure and function:    • Difference between Procedure and Func...  
union and union all:    • UNION AND UNION ALL SET OPERATOR IN O...  
char and varchar2:    • DIFFERENCE BETWEEN CHAR AND VARCHAR2 ...  
replace and translate:    • Difference between Replace and Transl...  
in and exists:    • IN VS EXISTS VS JOIN, performance  
rank and dense_rank:    • Row Number Vs Rank Vs Dense Rank  
delete and truncate:    • Difference between Delete and Truncat...  
%type and %rowtype:    • What is %type and %rowtype variable i...