This chapter introduces basic concepts and terminology needed for parallel query optimization, parallel sorting, and other parallel query topics, and provides an overview of the commands for working with parallel queries.
Other chapters that cover specific parallel processing topics in more depth include:
For details on how the Adaptive Server optimizer determines eligibility and costing for parallel execution, see Chapter 25, “Parallel Query Optimization.”
To understand parallel sorting topics, see Chapter 26, “Parallel Sorting.”
For information on object placement for parallel performance, see “Partitioning tables for performance”.
For information about locking behavior during parallel query processing, see System Administration Guide
For information on showplan messages, see “showplan messages for parallel queries”.
To understand how Adaptive Server uses multiple engines, see Chapter 3, “Using Engines and CPUs.”