Recent questions tagged joins - GATE CSE Doubts

0 votes

0 answers

Self Doubt - Nested Loop Join (No. of Seeks)
What do you mean by Seek? For Natural Loop Join, we calculate No. of Seeks are (nr + br). Assume that, Relation r is called the Outer Relation and Relation s is called the Inner Relation. (ni,bj) – ni represents total no. of tuples and bj represents no. of blocks in that relation. Reference (Korth) – For Block Nested-Loop Join –

asked Sep 10, 2019 in Databases by ayushsomani (13 points) | 18 views

0 votes

0 answers

Doubts Regarding join algorithm
What is the number of block access in Indexed Nested Loop join & Sort-merge Join??? given, No. of blocks in relation R = $B_{r}$ No. of blocks in relation S = $B_{s}$ No. of records in relation i = $r_{i}$ Join is like R x S & size of R is less than size of S

asked Jul 10, 2019 in Databases by MRINMOY_HALDER (37 points) | 6 views

To see more, click for the full list of questions or popular tags.

3,327 questions

1,581 answers

10,280 comments

89,915 users