Q145. Which two are true about Oracle Optimizer Statistics, their use, and their collection?

Posted on by Tran Anh

Q145. Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

  • A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
  • B. Index balanced B*Tree height is considered when evaluating the cost of using an index.
  • C. The Statistics Advisor can help recommend the best way to gather statistics.
  • D. Statistics collected using DBMS_STATS always yield the best optimizer result.
  • E. The Statistics Advisor generates actions for all recommendations.
Xem thêm:

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