Specifies the degree of parallelism for the scan of a stored table.
( prop table_name ( parallel degree ) )
is the table to which the property is to be applied.
is the degree of parallelism to use for the scan.
select * from t1
(prop t1 ( parallel 5 ) )
Specifies that 5 worker processes should be used for the scan of the t1 table.
The scan is performed using the specified number of worker processes, if available.
Partial plans can specify scan properties without specifying other portions of the query plan.
If a saved plan specifies the use of a number of worker processes, but session-level or server-level values are different when the query is executed:
If the plan specifies more worker processes than permitted by the current settings, the current settings are used or the query is executed using a serial plan.
If the plan specifies fewer worker processes than permitted by the current settings, the values in the plan are used.
These changes to the query plan are performed transparently to the user, so no warning messages are issued.