Please run explain from Ignite, not from H2 console - https://apacheignite.readme.io/docs/sql-performance-and-debugging#using-explain-statement
Here you can find info on proper IN usage in Ignite - https://apacheignite.readme.io/docs/sql-performance-and-debugging#sql-performance-and-usability-considerations Thanks! -- Yakov Zhdanov, Director R&D *GridGain Systems* www.gridgain.com 2017-09-15 4:50 GMT+03:00 Lucky <[email protected]>: > Hi > I have a table with 25,000,000 records. > The sql like this: > select fdatabasedid from databasedassign where fassingcuid in(3589 > ids) group by fdatabasedid have count(fassingcuid)>=3589 > It return 1500 records. > But It took 82 seconds!!! > > > I see the explain like this: > > > Any suggestions? > Thanks. > Lucky > > > >
