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 titles (parallel 1)

This example specifies the index to be used in the query, and sets the degree of parallelism to 5:

select * from titles 
    (index title_id_clix parallel 5)
where ...

To force a table scan, use the table name instead of the index name.