查询无法打满 cpu

测试 TPC-DS 1T，服务器是 3BE * 96 vcore，执行一个查询要 2s 多，是否可以优化？

SELECT
    item.i_brand_id brand_id,
    item.i_brand brand,
    sum(ss_ext_sales_price) sum_agg
FROM
    store_sales,
    item
WHERE
    store_sales.ss_item_sk = item.i_item_sk
GROUP BY
    item.i_brand,
    item.i_brand_id
ORDER BY
    sum_agg DESC,
    brand_id
LIMIT
    100;