Execution of a UDR in a query expression
One way to execute UDRs is as an expression in a query.
You can take advantage of parallel execution if the UDR is in an expression
in one of the following parts of a query:
- WHERE clause
- SELECT list
- GROUP by list
- Overloaded comparison operator
- User-defined aggregate
- HAVING clause
- Select list for parallel insertion statement
- Generic B-tree index scan on multiple index fragments provided that the compare function used in the B-tree index scan is parallelizable
- Virtual Table Interface (VTI) or Virtual Index Interface (VII) fragments, provided that all am_purpose functions for the VTI or VII are all parallelizable