search
Log In
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Sep 2019
  1. Satbir

    567 Points

  2. Bikram

    566 Points

  3. GAITONDE

    348 Points

  4. Vimal Patel

    87 Points

  5. Shaik Masthan

    38 Points

  6. BLACK_CLOUD

    14 Points

  7. sekhar_1621

    13 Points

  8. OgbeborBeatrice

    13 Points

  9. RAMYA.F

    9 Points

  10. vkw1111

    9 Points

Recent questions tagged joins

0 votes
0 answers 12 views
What do you mean by Seek? For Natural Loop Join, we calculate No. of Seeks are (nr + br). Assume that, Relation r is called the Outer Relation and Relation s is called the Inner Relation. (ni,bj) – ni represents total no. of tuples and bj represents no. of blocks in that relation. Reference (Korth) – For Block Nested-Loop Join –
asked Sep 10 in Databases ayushsomani 13 points 12 views
0 votes
0 answers 3 views
What is the number of block access in Indexed Nested Loop join & Sort-merge Join??? given, No. of blocks in relation R = $B_{r}$ No. of blocks in relation S = $B_{s}$ No. of records in relation i = $r_{i}$ Join is like R x S & size of R is less than size of S
asked Jul 10 in Databases MRINMOY_HALDER 27 points 3 views
To see more, click for the full list of questions or popular tags.
...