Parallel update operations

Product documentation


Abstract

IBM® Informix® performs some types of update operations in parallel.

Content

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.

Related information

12:10 - Database server operations that use PDQ
11:70 - Database server operations that use PDQ

Product Alias/Synonym

IDS

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

11.5, 11.7, 11.70, 12.1

Operating system(s):

AIX, HP-UX, Linux, Mac OS X, Solaris, Windows

Reference #:

7039808

Modified date:

2013-10-07

Translate my page

Machine Translation

Content navigation