|< < 31 > >|

Joins

Nested Loops Join

Analysis

Pages Rows per page
R NR pR
S NS pS

Count page reads:

  • Scan R once: NR

  • Scan S once for each row in R: (NR pR) NS.

  • Total: NR(1 + pR NS)

|< < 31 > >|