[WEBINAR] Bulletproof: How Today's Business Leaders Stay on Top

Parallel Query

Definition - What does Parallel Query mean?

Parallel query is a method used to increase the execution speed of SQL queries by creating multiple query processes that divide the workload of a SQL statement and executing it in parallel or at the same time.

Since each process works on something different at the same time, it greatly reduces overall execution time of the SQL statement. This is very beneficial for systems with multiple CPUs that can work on the processes.

Techopedia explains Parallel Query

A normal SQL processing without the parallel query feature is always performed by a single server process.

With the feature enabled, multiple processes are created to simultaneously work together on that single SQL statement and can dramatically improve the performance of data-intensive operations such as those in very large database systems.

Since the many processes can be split among multiple CPUs present, clustered and massively parallel systems, as well as symmetric multiprocessing systems can greatly benefit from it.

Parallel query processing occurs during the query optimization phase where the SQL server is looking for query index operations which might benefit from parallel operation.

When found, the server inserts exchange operators into the query execution plan in order to turn it into a parallel-query execution plan which can use more than one thread or process for execution.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.