Optimizing parallel query plans and execution
H. Leslie · 2002
It is noted that Tandem's loosely coupled multiprocessor machine is a natural environment for parallel database operations. Horizontally partitioned tables are supported by the Tandem system. It is shown how this environment is utilized in Tandem's NonStop SQL implementation. The Tandem architecture, parallel index maintenance, parallel use of partitioned tables, and repartitioning are discussed. It is shown that the use of the parallel execution in NonStop SQL can result in a large speedup in the execution of operations on partitioned and nonpartitioned data. A benchmark showed that parallel queries in NonStop SQL achieve linear speedup and scaleup for batch queries.>