What two steps could you take to make the query execute in parallel?

Examine the parallelism parameters for your instance:

Examine the Exhibit to view the query and its explain plan output.

All sessions use default parallelism settings.
What two steps could you take to make the query execute in parallel?

Examine the parallelism parameters for your instance:

Examine the Exhibit to view the query and its explain plan output.

All sessions use default parallelism settings.
What two steps could you take to make the query execute in parallel?

A.
Add a parallel hint.

B.
Decrease the value of PARALLEL_MIN_TIMETHRESHOLD.

C.
Increase the value of PARALLEL_MIN_SERVERS.

D.
Increase the value of PARALLEL_MAX_SERVERS.

E.
Decrease the value of PARALLEL_MIN_PERCENT.

Explanation:
A: You can rely on hints to set the degree of parallelism, but these can be hard to
set correctly.
B:
Decision tree for query parallelization



Leave a Reply 1

Your email address will not be published. Required fields are marked *