What are Aggregate functions? Functions like AVG(A), COUNT(*), MAX (A), and MIN(A) used in DB are useful but if used in the wrong way they can show visible performance aggregation If asked which of the following is more likely to use the index, the answer will be MAX(A), but why and not count…