In: Computer Science
MySQL:
What does it mean that a query goes parallel? When might this happen?
A query goes parallel means when Oracle runs SQL statements in parallel, multiple processes work together simultaneously to run a single SQL statement. By dividing the work necessary to run a statement among multiple processes.This is called parallel execution.
Parallel execution helps systems scale in performance by making optimal use of hardware resources.
Mostly a bank can use this parallelised programs to perform the millions of updates required to apply interest to accounts.
The most common example of using parallel execution is for decision support systems(DSS). Complex queries, such as those involving joins or searches of very large tables, are often best run in parallel.