Q44. Which three are true about the Oracle Optimizer?

Q44. Which three are true about the Oracle Optimizer?
A. It obeys all hints.
B. It updates stale object statistics in the Data Dictionary.
C. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
D. It can re-optimize execution plans after previous executions detect suboptimal plans.
E. It considers object statistics when generating execution plans for SQL statements.
F. It considers the filters in WHERE clauses when generating execution plans for SQL statements.

Bài viết cùng chủ đề:

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận