csun5285 commented on issue #50342: URL: https://github.com/apache/doris/issues/50342#issuecomment-3421548451
@ntestoc3 有两种可能的原因 1. ` (array_contains(cert_subject_root_domains, 'stackoverflow.com')) OR (array_contains(cert_subject_root_domains, 'cypress.com'))` 这个条件相比于单个条件的情况下执行过慢。 2. ` (array_contains(cert_subject_root_domains, 'stackoverflow.com')) OR (array_contains(cert_subject_root_domains, 'cypress.com'))` 这个条件下命中的行数相比于单个条件的情况下更多，导致后续的查询更慢。 `去掉查询1后面的cte查询部分， 只有base_data的查询2s就能返回，count或获取limit 10。` 这句话说的 base_data 的查询2s 是 select count() from table where 这种形式的话，就可以排除原因 1. 麻烦 @ntestoc3 提供 select count() from table where (array_contains(cert_subject_root_domains, 'stackoverflow.com')) OR (array_contains(cert_subject_root_domains, 'cypress.com')) 时的 count 和 单个条件下的 count，分别是多少。 以及相应的建表语句。 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
