Oracle7 Server Tuning

CHAPTER 6. Parallel Query Option

This chapter describes the Oracle Server parallel query option. This chapter discusses the following parallel query option topics:

parallel query processing

creating tables with subqueries in parallel

parallelizing SQL statements

setting the degree of parallelism

managing query servers

tuning for the parallel query option

parallel index creation

The information in this chapter applies only to the Oracle Server with the parallel query option.

Note: This option is not the same as the Parallel Server option of the Oracle Server. The Parallel Server option is not required to use this feature. However, some aspects of the parallel query option apply only to an Oracle Parallel Server.