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: • Views in database | Oracle, SQL Server |
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: • Replace and Translate in sql
in and exists: • IN VS EXISTS VS JOIN, performance
rank and dense_rank: • Row Number, Rank and Dense Rank in sq...
delete and truncate: • Difference between Delete and Truncat...
%type and %rowtype: • type and rowtype PL/SQL | difference ...
