Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ Supported SQL Statements/ Customized Hints for Sort-based Aggregation
Updated on 2025-06-25 GMT+08:00
View PDF
Share

Customized Hints for Sort-based Aggregation

Command format:

/*+ use_sort_base_agg=true */ <GROUP BY statement>;

Description:

This hint supports sort-based aggregation. Compared with HashAgg, sort-based aggregation reduces memory usage by loading data by group.

Example:

/*+ use_sort_base_agg=true */ select pad from dbtest1 group by pad;

Constraints:

Only 3.1.3 and later versions are supported.

Parent topic: Supported SQL Statements