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 : [ Ссылка ]
char and varchar2 : [ Ссылка ]
replace and translate : [ Ссылка ]
procedure and function : [ Ссылка ]
rank and dense_rank : [ Ссылка ]
delete and truncate : [ Ссылка ]
%type and %rowtype : [ Ссылка ]

свернуть