76. Join Algorithms | Nested Loop Join Algorithm | Block Nested Loop Join Algorithm | Database

In this video you will learn everything about Join Algorithms. As we have already discussed joins in queries chapter that join can be natural and conditional, But this video explains the internal working and access cost of the different approaches. In GATE 2008 questions has been asked from this topic, so don't skip it and prepare well.
In this video i am explaining three test cases to give you a detailed explanation of the working and access cost of Nested loop join algorithm and Block Nested loop join algorithm.
Learn Computer Organization for GATE, PSU & Other Competitive Exams:
• Computer Organization ...
Learn Linear Algebra for GATE, NET, PSU, & NIELIT: • Linear Algebra for GAT...
Learn Algorithm for GATE, NET, PSU, & NIELIT: • Algorithm for GATE, NE...
Learn Database for GATE, NET, PSU, & NIELIT: • Database for GATE, NET...
You can connect with us, links are given below:
facebook: / sumitsinghchauhanindia
Instagram: / thakur199316
Gradeup: grdp.co/z47ca1...
facebook_Page: / suregatesuccess
facebook_Group: / 343481552999674
#Subscribe_Us for more such videos.
Keep supporting keep learning
BEST OF LUCK

[@tejas__rathod_]

Best explanation , thank you

[@stark2461]

thank you so much for this video

[@SureGATESuccess]

I am glad it helped.

[@pranavpurkar9141]

i think AT 24:50 it should be min(x,y)+1 and not min(x+y)+1. pls verify once!!

[@chamahge3518]

min(x+y) expression has no meaning its min(x,y)

[@ashutoshtripathi8062]

Thank you very much it helped a lot ❤❤

[@SureGATESuccess]

I am glad it helped.

[@yasaswinibingimalla4602]

Thank you so much sir..

[@SureGATESuccess]

I'm glad you find it useful, best of luck 🤞

[@sindhujasekhar7109]

Indexed nested loop join Merge join Hash join explanation sir Atleast what is what Please sir

[@rohitbibe3648]

hello sir which is your next playlist ?

[@SureGATESuccess]

Hello dear, currently I am working on DBMS later I will complete CO

[@AshishKumar-rz7ul]

watched it first time then tried on pen and paper, watched again the intuition and formula are not same and the equation differs exponentially from the explanation not able to mug up the concept here. 1 hour got nothing in this topic

[@chocochips-as]

tru bro