フリー問題

問題文

A slow statement has a plan whose steps expect a handful of rows while the execution returns tens of thousands. Which first action follows from that?

選択肢

1. Refresh the figures that the collection keeps about the sampling of the data so the panel works from numbers that match the table as it is now.
2. Refresh the figures that the engine keeps about the distribution of the data so the planner works from numbers that match the table as it is now.
3. Rebuild the structure that the engine keeps about the ordering of the data so the planner works from numbers that match the table as it is.
4. Rewrite the statement so the engine reads fewer rows and the planner works from numbers that match the table as it is now.