试题详情
- 多项选择题Which three statements are true about SQL plan directives?（）
A、They are tied to a specific statement or SQL id.
B、They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
C、They are used to gather only missing statistics.
D、They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
E、They instruct the optimizer to create only column group statistics.
F、Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.
- B,D,E
关注下方微信公众号，在线模考后查看
热门试题
- Compare a typical Di
- A web app
- Which two statements
- By mistake，&en
- Your database is run
- In which
- 当JDBC程序提取SQL数据到Java中
- Which view should a
- Which componen
- You have
- Which two statements
- Another DBA
- To set the history r
- What happens if you
- Evaluate the SQL sta
- Your database&
- You used
- In which
- You want
- 在Oracle中，在SQL提示符下调用P