Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Block Access in Block Nested Loop Join
Aditya Bahuguna
asked
in
Databases
Jan 4, 2018
431
views
1
vote
1
vote
Aditya Bahuguna
asked
in
Databases
Jan 4, 2018
by
Aditya Bahuguna
431
views
answer
comment
Follow
share this
share
0 Comments
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
0
votes
No of blocks for R = $100$ blocks
No of blocks for S = $25$ blocks
Block nested loop join :
Keeping R as outer = $100+100 \times 25=2600$ Access
Keeping S as outer = $25 + 25 \times 100 =2525$ Access
Min$(2600,2525)=2525$ (Keeping S as outer)
saxena0612
answered
Jan 4, 2018
by
saxena0612
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
1
vote
1
vote
0
answers
1
Pawan Kumar 2
asked
in
Databases
Jan 2, 2018
593
views
Block nested loop join
Are block transfers and block access same ?
Pawan Kumar 2
asked
in
Databases
Jan 2, 2018
by
Pawan Kumar 2
593
views
block-nested-loop-join
2
votes
2
votes
2
answers
2
Shubhanshu
asked
in
Databases
Aug 18, 2017
1,356
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.
Shubhanshu
asked
in
Databases
Aug 18, 2017
by
Shubhanshu
1.4k
views
databases
natural-join
block-nested-loop-join
19
votes
19
votes
1
answer
3
KISHALAY DAS
asked
in
Databases
Oct 23, 2016
3,939
views
Block Nested Loop Join
Could Anybody tell me the concept of this block nested join? I have a dount regarding that whether we have to check each block of S for each block of R or each record of R....If R is the outer Loop
KISHALAY DAS
asked
in
Databases
Oct 23, 2016
by
KISHALAY DAS
3.9k
views
1
vote
1
vote
1
answer
4
Gaurangi Katiyar
asked
in
Databases
Jan 16, 2019
366
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
Gaurangi Katiyar
asked
in
Databases
Jan 16, 2019
by
Gaurangi Katiyar
366
views
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy