Parallel UDR in the select list
If you use a UDR in the select list and do not specify
a WHERE clause, the UDR can execute in parallel if any of the following
conditions are true:
- The GROUP BY clause is specified in the query.
- The ORDER BY clause is specified in the query.
- An aggregate such as MIN, MAX, AVG is specified in the query.
- The query is a parallel INSERT...SELECT statement.
- The query is a SELECT...INTO statement.
The next section shows a sample query with a UDR in the select list and no WHERE clause.