PolarDB必须得使用/*FORCE_IMCI_NODES*/ 强制制定列存储查询才可以，为什么？
PolarDB必须得使用/FORCE_IMCI_NODES/ 强制制定列存储查询才可以，为什么？/FORCE_IMCI_NODES/SELECT
down_user_id,
COUNT(*) AS orderNums,
SUM( pay_price ) AS totalPrice,
SUM( CASE WHEN status = 1 THEN pay_price ELSE 0 END ) AS successTotalPrice,
SUM( CASE WHEN status = 1 THEN recharge_price ELSE 0 END ) AS successTotalRechargePrice,
SUM( CASE WHEN status = 1 THEN cost ELSE 0 END ) AS successTotalCost,
SUM( CASE WHEN status = 1 THEN profit ELSE 0 END ) AS successTotalProfit,
SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ) AS orderSuccessNums
FROM
rs_order t -- FORCE INDEX ( index_createtime_downUserId )
WHERE
(
t.create_time BETWEEN "2020-04-25 00:00:00"
AND "2024-05-26 00:00:00" )
GROUP BY
t.down_user_id
ORDER BY
t.down_user_id DESC
LIMIT 10
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
阿里云关系型数据库主要有以下几种：RDS MySQL版、RDS PostgreSQL 版、RDS SQL Server 版、PolarDB MySQL版、PolarDB PostgreSQL 版、PolarDB分布式版 。