Register

Recent questions tagged block-nested-loop-join

0 0 votes
1 1 answer
1.1k
1.1k 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...
User Avatar
0 0 votes
0 0 answers
794
794 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...
User Avatar
1 1 vote
0 0 answers
1.4k
1.4k views
Block nested loop join
Are block transfers and block access same ?
User Avatar
1 1 vote
1 1 answer
805
805 views
ACE Test Series, Gate2018
User Avatar
1 1 vote
0 0 answers
726
726 views
block nested query
please cjheck this
User Avatar
2 2 votes
2 2 answers
3.1k
3.1k 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...
User Avatar
To see more, click for the full list of questions or popular tags.