フリー問題

問題文

An interactive screen shows the first twenty rows of a long result and the users care only about how quickly those first rows appear. Which parameter expresses that preference to the optimizer?

選択肢

1. The one that sets the level of dynamic sampling because it lets the optimizer collect extra statistics while it is compiling the statement.
2. The one that sets the cost adjustment for indexes because it makes the optimizer treat index access as cheaper than it would otherwise.
3. The one that sets the cursor sharing behavior because it decides whether the literals in the text are replaced with markers before the statement is matched.
4. The one that sets the optimizer goal because it chooses between the best throughput for the whole result and the fastest return of the first rows.