拿下这两个 SQL 结果提供下:
explain analyze SELECT /*+ use_index(trade_order_seller, idx_seller_id_create_time_us) */
id,
order_no,
sub_order_no,
biz_type,
biz_channel,
biz_code,
biz_id,
abs(sub_order_status) AS sub_order_status,
buyer_id,
buyer_name,
seller_id,
seller_name,
pay_amou…