Actually H2 can use index for IN operator, but using JOIN instead of IN may be still useful.
Sergi 2017-05-01 12:40 GMT+03:00 Nikolai Tikhonov <[email protected]>: > Hi, > > The page [1] contains also workaround for IN operation. You can use JOIN > instead of IN. > > Sergi, > > Will this tip actual for 2.0 version yet? > > 1. https://apacheignite.readme.io/docs/sql-performance-and-debugging#sql- > performance-and-usability-considerations > > On Sun, Apr 30, 2017 at 1:50 PM, kmandalas <Kyriakos.Mandalas@ > iriworldwide.com> wrote: > >> After investigation more I run into the following: >> >> https://apacheignite.readme.io/docs/sql-performance-and-debu >> gging#sql-performance-and-usability-considerations >> >> So, cause my query has IN clause no indexing will be used anyway. >> >> Could you please elaborate more on this topic and if/what will change at >> version 2.0? Should I open a different topic better? >> >> >> >> -- >> View this message in context: http://apache-ignite-users.705 >> 18.x6.nabble.com/Distributed-Closures-VS-Executor-Service-t >> p11192p12314.html >> Sent from the Apache Ignite Users mailing list archive at Nabble.com. >> > >
