What must be the correct order of steps that the optimizer executes based on the ID column the execution plan?

Refer to the Exhibit.

Execution plan:

What must be the correct order of steps that the optimizer executes based on the ID column the execution plan?

Refer to the Exhibit.

Execution plan:

What must be the correct order of steps that the optimizer executes based on the ID column the execution plan?

A.
3, 5, 4, 6, 7

B.
3, 5, 4, 7, 6

C.
3, 4, 5, 7, 6

D.
4, 5, 3, 7, 6

Explanation:



Leave a Reply 5

Your email address will not be published. Required fields are marked *


raka

raka

I agree with sasa.

Answer: B

Caesar

Caesar

In real exam I was confused because I need choose between next variants:

1) 3,5,4,2,6,7
2) 5,4,3,2,7,6

Both are incorrect as I think, because correct must be 3,5,4,2,7,6

mt

mt

exactly caesar, i had exam today and neither of options was right!

3,5,4,2,7,6 wasn’t there, so i chose 3,5,4,2,6,7 which was the closest

that’s not the only question in real test that was imho wrong, so be aware

vvp

vvp

3-5-4-2-7-6-1-0