Changes in HeatWave 8.0.23-u2 (2021-03-15, General Availability)

Functionality Added or Changed

• Support was added for the following aggregate functions:

  • STD()

  • STDDEV()

  • STDDEV_POP()

  • STDDEV_SAMP()

  • VAR_POP()

  • VAR_SAMP()

  • VARIANCE()

  See Aggregate Functions. (WL #14479)

• HeatWave now uses a priority-based scheduling mechanism based on query cost estimates to schedule queries for execution. Previously, queries were executed in the order of arrival. The scheduling mechanism prioritizes short running queries over long running queries to reduce overall query execution wait times. For more information, see Auto Scheduling. (WL #14423)