Implicit UDR execution of a comparison operator
When you create opaque data types, you can create overloaded routines for comparison operators such as equal (=) or greaterthanorequal (>=).
The following
sample query selects rows using a filter on the UDT column:
SELECT * FROM tab WHERE udt_col = "xyz";The
database server converts the comparison operator = to call the equal UDR
on the udt_col column. If the table tab is fragmented,
the following operations can execute in parallel:
- Multiple scans of the table can execute in parallel, one scan on each fragment.
- Multiple = comparison operators can execute in parallel, one operator per fragment of table tab.