Duality between Set and Join Operators For two tables A and B with the same columns, set intersection select * from A intersect select * from B can be expressed as a semi-join select distinct * from A where (col1,col2,…) in (select col1,col2,… from B) Likewise, set difference select * from A intersect select * from B can be expressed as an anti-join select distinct * from A where (col1,col2,…) not in (select col1,col2,… from B) Transforming set into join operators expands optimizer search space. Optimizer could explore new, previously unavailable join order permutations - Study24x7
Social learning Network

Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18

Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18
trilok sharma
27 Apr 2019 11:49 AM study24x7 study24x7

Duality between Set and Join Operators For two tables A and B with the same columns, set intersection select * from A intersect select * from B can be expressed as a semi-join select distinct * from A where (col1,col2,…) in (select col1,col2,… from B) Likewise, set difference...

See more

NET IIT Entrance GATE
Like Comment Share
study24x7
Write a comment

Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/live/makepost.php on line 893

Get the App

Download the Study24x7 App, so you can connect and collaborate.

study24x7
study24x7
Most Related Articles

    Warning: count(): Parameter must be an array or an object that implements Countable in /var/www/html/live/makepostRltdArtcl.php on line 8