sql优化问题，group by 多个列

Question

SELECT
        type,
    store_name,
    store_id,
    business_type,
    business_type_desc,
    DATE_FORMAT(alipay_created_time,'%Y-%m-%d') as day,
    sum(in_amount) as in_amount,
    sum(out_amount) as out_amount
    FROM oms_alipay_record
    group by business_type, store_id, day

想请问下像这种group by 多个列的sql怎么优化，网上都搜了下很难

Answer 1

查询效率慢还是sql不美观