kongshanxuelin opened a new issue, #11406:
URL: https://github.com/apache/ignite/issues/11406

   this is query very slow,aboult 1s:
   SELECT f1,f2,f3 FROM table_x WHERE   f1IN (107,108) AND f2= 1 AND ydate = 
20230616
   
   this is query very fast,about 20ms:
   SELECT f1,f2,f3 FROM table_x WHERE   f1=107 AND f2= 1 AND ydate = 20230616
   UNION ALL 
   SELECT f1,f2,f3 FROM table_x WHERE   f1=108 AND f2 = 1 AND ydate = 20230616
   
   this is why?


-- 
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]

Reply via email to