Apache Doris 中文技术论坛
Questions Tags Users Badges

前缀索引命中问题

Asked Oct 25, 2024 Modified Jan 1, 0001
Viewed 43
2.1

如果排序列为x1,x2,x3,x4 , x1+x2 < 32 字节,是不是查询条件得x1 + x2才能命中索引,加快查询。单独x1或单独x2都不行?

edited Jan 1, 0001
zlhxxx158
asked Oct 25, 2024
1 Answers

如果x1不是varchar类型,单独x1是可以命中索引的,x2+x1也可以命中索引,doris会自动优化。

edited Jan 1, 1970
黄海军@SelectDB5188
answered Oct 25, 2024
Related Questions
Doris 2.1.6 SQL_BLOCK_RULE 命中后错误信息不正确,显示为未知列错误而非规则拦截提示
1 answers
routine_load失败
doris升级问题
1 answers
doris 2.1.8写入速度非常慢,IOutil占满但写入速度很慢,查询速度没有影响。
1 answers
查询Paimon的Catalog经常超时,查询不到数据。
1 answers
spark-doris-connector,Unknown column 'null' in 'table list'
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.