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

前缀索引命中问题

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

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

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

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

edited Jan 1, 1970
黄海军@SelectDB5098
answered Oct 25, 2024
Related Questions
Workload Group的资源限制是怎么做的?
Flink Doris Connector 开启攒批 数据丢失
1 answers
Doris2.1.10备份前创建仓库的方式
1 answers
insert into 插入catalog查询少数据、丢失数据
查询视图时报错 [INTERNAL_ERROR]VSlotRef env_code have invalid slot id
1 answers
upsert流UNIQUE KEY里主键修改,doris查询有两条数据,请问针对主键修改有什么方案?
2 answers

Terms of service Privacy policy

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