問題文
A newspaper archive team must find a supplier name that appears somewhere inside long description text on several unrelated objects, and the team does not know which field holds it. Which language should the search use, and why?
選択肢
- The search language, because it reads the same tables as the query language but applies the filter after the rows have been fetched, which is why it can look inside long text that the query language cannot filter on at all.
- The query language against each object in turn, because the results can then be sorted and counted in the same statement, so the team works through the objects one at a time.
- The search language, because it is meant for the case where you do not know which object or field holds the data, and it splits text into terms and searches its own index.
- The query language with a filter that matches text anywhere in the field, because it can return rows from several objects in one statement, and the unknown field is covered by the pattern.