New aggregate functions
BIT_XOR_AGG enable bitwise aggregation of integer columns and columns that can be converted or rounded to integer values.
Bitwise aggregation functions enable bitwise type processing directly in SQL. Use of these new functions improves overall query performance by eliminating unnecessary data movement and by taking full advantage of other database capabilities such as parallel processing.
This practice shows how to use the new
BIT_XOR_AGG bitwise aggregate functions at the bit level of records within a group.
BIT_XOR_AGG return the result of bitwise AND, OR and XOR operations respectively. These aggregates can be performed on a single numeric column or an expression. The return type of a bitwise aggregate operation is always a number.