Table: USER_MVIEW_AGGREGATES
Description of the materialized view aggregates created by the user
| Column Name | Description |
|---|---|
| AGG_FUNCTION | Name of the aggregation function, one of the following: COUNT, SUM, MIN, MAX, AVG, VARIANCE, STDDEV |
| CONTAINER_COLUMN | Name of this column in the container table |
| DISTINCTFLAG | Set to Y is this is a DISTINCT aggregation |
| MEASURE | The SQL text of the measure, excluding the aggregation function |
| MVIEW_NAME | Name of the materialized view |
| OWNER | Owner of the materialized view |
| POSITION_IN_SELECT | Position of this aggregated measure with the SELECT list |