Full-stack dev quiz question #30

Full-stack dev quiz question #30

quiz

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.

  1. hash join
  2. window function
  3. fast join
  4. merge join 
  5. nested loops
  6. distinctive join
  7. inclusive join

For the correct answer scroll down

.

.

.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

.

.

.

The correct answers are a, d, e.

If you like what I do, consider buying me a coffee :)

Buy me a coffeeBuy me a coffee