As you are aware, the job of aggregate functions is to summarize column data values stored in rows. For example, totals of a column, minimum/maximum value in a range of values, total number of rows present in a column etc. These aggregates are divided into two groups i.e. Math and Statistical. SUM, AVG, MIN, MAX, [...]

The Explain Command in Teradata provides an English explanation of the steps that the AMP (Access Module Processor) goes through while running a SQL query. As you know it is the job of Parsing Engine (PE) to create the steps for accessing the data. When the ‘EXPLAIN’ command is submitted with any SQL statement, the [...]