IN VS EXISTS VS JOIN, performance
This video demonstrates the performance effects of using an exists clause instead of an IN clause, also it shows how we can update a simple sub query having an IN clause with an EXISTS or JOIN statement. It also shows that joining would consider the null data, where as an IN clause would neglect null values.
If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below :
union and union all : • UNION AND UNION ALL SET OPERATOR IN ORACLE...
char and varchar2 : • DIFFERENCE BETWEEN CHAR AND VARCHAR2 DATAT...
replace and translate : • Replace and Translate in sql
procedure and function : • Difference between Procedure and Function
rank and dense_rank : • Row Number, Rank and Dense Rank in sql | A...
delete and truncate : • Difference between Delete and Truncate and...
%type and %rowtype : • type and rowtype PL/SQL | difference betwe...
