QUESTION NO: 381
View the Exhibit exhibit1 to examine the series of SQL commands.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row
of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.
Which statement is true if the SQL query in exhibit1 is executed again when the value
of OPTIMIZER_MODE is set to FIRST_ROWS?
A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to
FIRST_ROW during its creation.
Answer: B
查看图表exhibit1检查一系列SQL命令。
查看图表exhibit2检查可用在SQL计划基线的计划。当优化器模式设置为第一行时,创建图表的第一行基线。
如果当优化器模式值设置为第一行, exhibit1图表中的SQL查询再次执行,哪种说法是真实的?
B.优化程序使用exhibit2第二行计划,因为它是一个为公众所接受的计划。