Parallel Processing

Parallel processing requires more memory than serial processing.

The configuration parameters that affect parallel processing are:

Each worker process makes its own copy of the query plan in space borrowed from the procedure cache. The coordinating process keeps two copies of the query plan in memory.