03 Query Processing Flashcards

1
Q

Naive NLJ Costs

A

m + m*n

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Block NLJ Costs

A

M + M * N

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Sort-Merge Join Costs

A

M + N

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Hash Join Cost

A

M + N

How well did you know this?
1
Not at all
2
3
4
5
Perfectly