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 8, “Parallel Query Optimization.”
To understand parallel sorting topics, see Chapter 9, “Parallel Sorting.”
For information on object placement for parallel performance, see “Partitioning tables for performance” on page 99 in the book Performance and Tuning: Basics.
For information about locking behavior during parallel query processing, see System Administration Guide
For information on showplan messages, see “showplan messages for parallel queries” on page 114 in the book Performance and Tuning: Monitoring and Analyzing for Performance.
To understand how Adaptive Server uses multiple engines, see Chapter 4, “Using Engines and CPUs,” in the book Performance and Tuning: Monitoring and Analyzing for Performance.
