Aggregates

Use this page to view information about the user-defined aggregates in a database.

User-defined aggregates extend the functionality of the database server by performing aggregate computations. The page displays the following information about the aggregates:

• Aggregate Name
• Owner
• Initialization UDR: The user-defined routine (UDR) that initializes the data structures required for the aggregate computation.
• Iterator UDR: The UDR that performs the sequential iteration for the aggregate. It merges a single value with a partial result and returns the updated partial result.
• Combine UDR: The UDR that merges one partial result into the other and returns the updated partial result. It allows the aggregate to execute in a parallel query.
• Final UDR: A UDR that converts a partial result into the result type. It performs the post-iteration tasks for the aggregate.
• Handles Nulls: Indicates whether rows with NULL aggregate argument values contribute to the aggregate computation. A check mark in the column means that rows with NULL aggregate argument values contribute to the computation.