Examine this command: SQL > exec DBMS_STATS.SET_TA...
多选题

Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?()

发布日期:2020-04-10

A.Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

B.Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

C.Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

D.Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E.Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定