多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题