estimates the number of block accesses to compute the join . the formula is : b indexjoin p1 , p2 , idx = b p1 + r p1 b idx + r indexjoin p1 , p2 , idx concode_field_sep IndexInfo ii concode_elem_sep Plan p1 concode_elem_sep Plan p2 concode_elem_sep String joinfield concode_elem_sep Schema sch concode_field_sep Schema schema concode_elem_sep int distinctValues concode_elem_sep int recordsOutput concode_elem_sep Scan open
int function ( ) { return p1 . blocksAccessed ( ) + ( p1 . recordsOutput ( ) * ii . blocksAccessed ( ) ) + recordsOutput ( ) ; }