Hi Because the H2 engine works this way.
Look carefully into the documentation [1] [1] https://apacheignite.readme.io/docs/sql-queries#performance-and-usability-considerations 2016-06-07 7:37 GMT+03:00 pragmaticbigdata <amits...@gmail.com>: > Great. The query worked now and it is 50% faster than the in clause query. > Could you detail on the internals of why passing the object array directly > didn't work and how did an [] inside an [] worked out? > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Self-Join-Query-As-An-Alternative-To-IN-clause-tp5448p5473.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov