Register

Nested loop join

1,584 views
1 1 vote

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Self doubtNext → · ME Test Series
← Previous in category · Relation_5_36Next in category → · Self doubt
Position:
Show:

Related questions

1 1 vote
1 1 answer
754
754 views
Gaurangi Katiyar asked Jan 16, 2019
754 views
Nested loop join
Let a relation R with n tuples occupying X blocks and relation S with m tuples occupying Y blocks. 5 blocks of main memory are allocated to store records of R and S to pe...
1 1 vote
1 1 answer
683
683 views
Aditya Bahuguna asked Jan 4, 2018
683 views
Block Access in Block Nested Loop Join
1 1 vote
0 0 answers
1.3k
1.3k views
Pawan Kumar 2 asked Jan 2, 2018
1,321 views
Block nested loop join
Are block transfers and block access same ?
2 2 votes
2 2 answers
3.0k
3.0k views
Shubhanshu asked Aug 18, 2017
3,027 views
Block Nested Loop Join
Consider a relation R with 2000 records and relation S with 500 records. Size of each record is 5 Byte and block size is 100 Byte, then minimum number of block access tha...