Register

Nested loop join

673 views
1 votes
1 votes

User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
Gaurangi Katiyar asked Jan 16, 2019
376 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 perform join. What will be the access cost of a) R join S b) S join R
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...
User Avatar
1 votes
1 votes
1 answer
2
Aditya Bahuguna asked Jan 4, 2018
443 views
Block Access in Block Nested Loop Join
User Avatar
1 votes
1 votes
0 answers
3
Pawan Kumar 2 asked Jan 2, 2018
585 views
Block nested loop join
Are block transfers and block access same ?
Are block transfers and block access same ?
User Avatar
2 votes
2 votes
2 answers
4
Shubhanshu asked Aug 18, 2017
1,370 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 that are needed block nested loop join. I think its answer should be 2525.
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...
User Avatar
Link Copied!