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.