Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Free Preparation Discussions
MENU
Oracle Exam 1Z0-084 Topic 2 Question 33 Discussion
Actual exam question for
Oracle's
1Z0-084 exam
Question #: 33
Topic #: 2
[All 1Z0-084 Questions]
Topic #: 2
Which Optimizer component helps decide whether to use a nested loop join or a hash join in an adaptive execution plan?
Suggested Answer:
C
In an adaptive execution plan, the Optimizer makes runtime decisions between nested loop and hash joins using a statistics collector. The collector is a row source that collects statistics about the rows it processes and can adapt the plan based on the number of rows processed.
Oracle Database SQL Tuning Guide, 19c
Currently there are no comments in this discussion, be the first to comment!