Multiple choice technology databases

What is true about the explain plan? Choose all that apply

  1. The more heavily indented an access path is, the earlier it is executed

  2. The more heavily indented an access path is, the later it is executed

  3. If two steps are indented at the same level, the uppermost statement is executed first

  4. If two steps are indented at the same level, the uppermost statement is executed last
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

In an execution plan, indentation shows parent-child relationships. The most indented operations are innermost (executed first) and feed their results to parent operations. At the same indentation level, top operations execute before bottom ones, following a left-to-right, top-to-bottom flow within the plan tree.

Keep practicing — related questions