Register

block nested query

716 views

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · self doubtNext → · Computer Network
← Previous in category · Please solve This QNext in category → · Gateforum
Position:
Show:

Related questions

2 2 votes
2 2 answers
3.0k
3.0k views
Shubhanshu asked Aug 18, 2017
3,028 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...
1 1 vote
0 0 answers
1.3k
1.3k views
Pawan Kumar 2 asked Jan 2, 2018
1,322 views
Block nested loop join
Are block transfers and block access same ?
0 0 votes
0 0 answers
782
782 views
sushil1997 asked Sep 28, 2018
782 views
Nested Quantifiers
If we have ∀x(p(x)) then in boolean algebra form we can write this statement as (P1 + P2) where + signifies OR which makes it very easy to deal with. So likewise is there...
0 0 votes
1 1 answer
1.1k
1.1k views
Abhisek Tiwari 4 asked Dec 19, 2018
1,069 views
MadeEasy Test Series: Databases - Joins
Table T1 4000 record and 50 disk block Table T2 300 record 20 block has joined with specific condition, No index is available if nested loop join with most appropriate t...