在查询条件中用 partition 字段 和 用聚合索引字段(非partition)查询 性能差别大吗? #35625
Closed
javaofferss
started this conversation in
RFC
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
我们有一个表:聚合索引有: customer_id, log_date. 按照 PARTITION BY RANGE(
log_date). 我们在sql条件中并不会用到log_date这个字段而是用customer_id. 用log_date和不用log_date去查询,二者查询性能差别大吗? 目前我们有900多个分区(log_date: 当天导入时间: yyyy-MM-dd).Beta Was this translation helpful? Give feedback.
All reactions