问题

Examine the parameter for your database instance:You generated the execution plan for the

Examine the parameter for your database instance:You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:Identify the reason why the optimizer chose different execution plans.（）

A. The optimizer used a dynamic plan for the query.

B. The optimizer chose different plans because automatic dynamic sampling was enabled.

C. The optimizer used re-optimization cardinality feedback for the query.

D. The optimizer chose different plan because extended statistics were created for the columns used.

参考答案

您可能感兴趣的试题

The regulations make it safer for you to use your credit card for shopping on the Intern

答案解析
I’d just as soon you ____ me to stand up for your friend because he is obviously in the wr

答案解析
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?（）

答案解析
---Youshould have prepared your speech for the mee

答案解析
______ for your help we'd never have been able to get over the difficulties. A) Had it not

答案解析
View the Exhibit for some of the parameter settings. You start a session and issue the fol

答案解析