Recent questions tagged block-nested-loop-join / GATE Overflow for GATE CSE

0 votes

1 answer

1

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 table in outer loop No of block access to read the data are ………. what it would be if nested block joined used?

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...

Abhisek Tiwari 4

613 views

Abhisek Tiwari 4 asked Dec 19, 2018

0 votes

0 answers

2

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 any way to have a view of a statement like ∀x∀y(R(x,y)) into boolean form?

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 the...

sushil1997

482 views

sushil1997 asked Sep 28, 2018

0 votes

0 answers

3

compile design syntax directed defination

Ronish Jariwala 1

486 views

Ronish Jariwala 1 asked Apr 15, 2018

1 votes

0 answers

4

Block nested loop join
Are block transfers and block access same ?

Are block transfers and block access same ?

Pawan Kumar 2

587 views

Pawan Kumar 2 asked Jan 2, 2018

1 votes

1 answer

5

ACE Test Series, Gate2018

ashish pal

438 views

ashish pal asked Nov 29, 2017

1 votes

0 answers

6

block nested query
please cjheck this

please cjheck this

raviyogi

400 views

raviyogi asked Nov 10, 2017

2 votes

2 answers

7

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...

Shubhanshu

1.4k views

Shubhanshu asked Aug 18, 2017

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