QUESTION 480
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 Z??http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcHRpbWl6ZXIgdXNlcyB0aGUgcGxhbiBpbiB0aGUgc2Vjb25kIHJvdyBvZiB0aGUgZXhoaWJpdDIgYmVjYXVzZSBpdCBpcyBhbiBhY2NlcHRlZCBwbGFuLjwvc3Ryb25nPjxiciAvPg0KQy4gVGhlIG9wdGltaXplciB1c2VzIHRoZSBwbGFuIGluIHRoZSBmaXJzdCByb3cgb2YgdGhlIGV4aGliaXQyIGJlY2F1c2UgaXQgaXMgdGhlIGxhdGVzdCBnZW5lcmF0ZWQgcGxhbi48YnIgLz4NCkQuIFRoZSBvcHRpbWl6ZXIgdXNlcyB0aGUgcGxhbiBpbiB0aGUgZmlyc3Qgcm93IG9mIHRoZSBleGhpYml0MiBiZWNhdXNlIE9QVElNSVpFUl9NT0RFIHdhcyBzZXQgdG88YnIgLz4NCkZJUlNUX1JPVyBkdXJpbmcgaXRzIGNyZWF0aW9uLjxiciAvPg0KQ29ycmVjdCBBbnN3ZXI6IEI8L3A+DQo8aHIgLz4NCjxwPrLpv7TVuc28MSC87LLpU1FMw/zB7tDywdA8L3A+DQo8cD6y6b+0zbwyILzssulTUUy8xruuu/nP37/J08O8xruuPC9wPg0KPHA+PGltZyBhbHQ9"这里写图片描述" src="https://www.cppentry.com/upload_files/article/57/1_fz4ss__.jpg" title="" />
当OPTIMIZER_MODE设置成FIRST_ROWS时，在第一行中的基线创建。
当OPTIMIZER_MODE的值设置成FIRST_ROWS时，如果图1中的SQL查询再执行一遍 那么哪一句是正确的