To use a function-based index on a table, which of the following must occur? (Choose three.)
A. A query rewrite must be enabled for the session or instance.
B. The CBO must be used.
C . You must have a query rewrite system privilege.
D . The function-based index must be on a materialized view.
E. The table must be analyzed.
Explanation:
Answer A, B and E: A function-based index relies on statistics gathered for the CBO. Also, the query will be rewritten by the optimizer to use the function or expression, but only if the query rewrite parameters have been set.
No comments:
Post a Comment