【已解决】where查询时只用排序字段中某几个字段,前缀索引还会生效吗

Viewed 46

Doris设置排序列时指定了多个字段,但是where查询时只用了某几个字段,此时前缀索引会生效吗?
比如排序字段是:userid,name,pv,uv
下面哪种查询前缀索引会生效
1、where userid = '' and name = '' and pv = '' and uv = ''
2、where userid = '' and name = ''
3、where userid = ''
4、where name = ''
5、where name = '' and pv = ''

1 Answers