Query level parallel clause examples

To specify the degree of parallelism for a single query, include parallel after the table name. This example executes in serial:

select * from huge_table (parallel 1)

This example specifies the index to use in the query, and sets the degree of parallelism to 2:

select * from huge_table (index ncix parallel 2)

See “Suggesting a degree of parallelism for a query” for more information.