Oracle7 Server Tuning
Parallel Query Option
The parallel query option allows you to parallelize queries and certain DDL operations for faster performance. Parallelization is the process of breaking down the statement into smaller portions and executing each portion on a separate server process in parallel. Queries, index creation, and table creation with a subquery can all be parallelized. Chapter 6, "Parallel Query Option", describes parallel query execution.