Combining max and min aggregates

When used separately, max and min aggregates on leading index columns use special processing if there is no where clause in the query:

However, when min and max are used together, this optimization is not available. The entire leaf level of an index is scanned to locate the first and last values.

min and max optimizations are not applied if: