Indexima supports SQL aggregate functions to improve the execution time performance of SQL queries using such aggregate functions.
As a reminder, aggregate functions compute a single result from a set of input values.
The aggregate functions that accept an expression parameter can be modified by the keywords
If neither is specified, the result is the same as if "
ALL" were specified.
DISTINCT Modifies the expression to include only distinct values that are not NULL
ALL Includes all rows where expression is not NULL
The built-in aggregate functions are listed below
Average (arithmetic mean) of all input expression values
|Number of input rows, including rows that are NULL|
|Number of input rows where expression value is not equal to NULL|
Maximum value of expression across all input values
|Minimum value of expression across all input values|
|Sum of expression across all input values|