欢迎来到在线考试题库网 在线考试题库官网
logo
全部科目 > Oracle认证考试 > 1Z0-060

多项选择题

Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality feedback?()


    A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
    B. The optimizer can re optimize a query only once using cardinality feedback.
    C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
    D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
    E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题