All of the following features of a relational query or of the relational database that it accesses are considered by the relational query optimizer, except ____.
A) whether a search argument in the query is a unique attribute in the database
B) whether a search argument in the query involves an indexed attribute
C) the number of rows of output the query produces
D) the number of rows of the database tables involved
E) whether a join attribute in the query involves an indexed attribute

Question

Quizplus · Accepted Answer

The relational query optimizer does not consider the number of rows of output the query produces. Instead, it focuses on aspects like uniqueness, indexing, and the size of the database tables to determine the most efficient way to execute a query.

All of the Following Features of a Relational Query or of the Relational