Parallel update operations
IBM® Informix® performs some types of update operations in parallel.
The database server takes the following two steps to process UPDATE statements:
1. Fetches the qualifying rows.
2. Applies the action of updating.
The database server performs the first step of an UPDATE statement in parallel, with the following exceptions:
- The UPDATE statement contains an OR clause and the optimizer chooses an OR index to process the OR filter.
- The UPDATE statement contains a subquery that the optimizer converts into a join.
More support for:
Software version: 11.5, 11.7, 11.70, 12.1
Operating system(s): AIX, HP-UX, Linux, OS X, Solaris, Windows
Reference #: 7039808
Modified date: 07 October 2013