I do not understand your points exactlly. but I have post the screenshot here. It is the output of the "explain" query. Can you see that?
At 2017-09-16 15:28:23, "Dmitriy Setrakyan" <[email protected]> wrote: Lucky, We would like to see the output of the "EXPLAIN" command for the query that takes a long time, so we could make suggestions. Can you post it here? D. On Fri, Sep 15, 2017 at 11:50 PM, Lucky <[email protected]> wrote: Hi , Yakov Zhdanov Actually I did not run H2 console, I run like this : cache.query(newSqlFieldsQuery("explain select id from assignInfo ")); I change to like this: newSqlFieldsQuery("select * from Person p join table(id bigint = ?) i on p.id = i.id").setArgs(newObject[]{newInteger[]{2,3,4}})) but it also need take 82 seconds.That did not change anything. Any other suggestion? Thanks a lot. Lucky At 2017-09-15 22:17:30, "Yakov Zhdanov" <[email protected]> wrote: 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
