Statements that involve SPL routines are not executed in parallel. However, statements within procedures are executed in parallel.
When the database server executes an SPL routine, it does not use PDQ to process nonrelated SQL statements contained in the procedure. However, each SQL statement can be executed independently in parallel, using intraquery parallelism when possible. As a consequence, you should limit the use of procedure calls from within data manipulation language (DML) statements if you want to exploit the parallel-processing abilities of the database server. For a complete list of DML statements, see the IBM Informix: Guide to SQL Syntax.
The database server uses intraquery parallelism to process the statements in the body of an SQL trigger in the same way that it processes statements in SPL routines.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]