Time series routines that run in parallel

For time series routines to run in parallel, the following conditions are required:

• The table that contains the time series data is fragmented, by any fragmentation method.
• Parallel database queries are enabled: the PDQPRIORITY environment variable is set to a value other than OFF and the MAX_PDQPRIORITY configuration parameter is set to a value other than 0 or 1.
• The routine is referenced in the WHERE clause of a SELECT statement. Routines that are referenced in the Projection clause are not run in parallel.
• The routine must select data from a table that contains time series data or a time series system table. Routines that insert, update, or delete data do not run in parallel.
• The routine cannot call another routine that cannot run in parallel. If a routine that can run in parallel calls another routine that cannot run in parallel, neither routine runs in parallel.
• The routine cannot include a collection data type as an argument or return value. For example, if the Intersect function includes a parameter that has a SET data type, the function is not run in parallel.

The routines in the Related reference list can run in parallel.