Even a simple join between two database tables can be executed in a few different ways. Thirtieth question is about join implementations.
When a database has to execute the following query, the engine has to choose a method of joining tables A and B.
select *
from A
join B on id = parentId
Which of the following names are join implementations that you can see on execution plans? Choose the correct answer.
- hash join
- window function
- fast join
- merge join
- nested loops
- distinctive join
- inclusive join
For the correct answer scroll down
.
.
.
.
.
.
The correct answers are a, d, e.