フリー問題

問題文

A statement filters on a column that is wrapped in a function call and its plan shows a full pass over a large table. What does that combination indicate?

選択肢

1. The predicate has to be evaluated twice on that column so the engine reads the whole table once for each of the two passes that it has to make.
2. The predicate is rewritten by the collection on that column so the engine reports the whole table as the target of the statement.
3. The predicate is unable to use an ordinary index on that column so the engine has to read the whole table on each execution of the statement.
4. The predicate is cached with the plan for that column so the engine keeps the whole table in memory between the executions.