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

0 votes
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 – 

in Databases 13 points 12 views

Please log in or register to answer this question.

...