I'll try to reproduce your case tomorrow using these cardinalities. Meanwhile try to execute the following query.
EXPLAIN ANALYZE SELECT DISTINCT * FROM "Activity".activity activity0 LEFT OUTER JOIN "Activity".activityuseraccountrole activityuseraccountrole0 ON activity0.activity_Id=activityuseraccountrole0.activity_Id I suspect the IN condition is the culprit. 2016-05-26 17:26 GMT+03:00 jan.swaelens <[email protected]>: > And indeed, I am running with these options: > > /MEM_ARGS="-XX:PermSize=256m -Xms1g -Xmx8g -XX:+UseParNewGC > -XX:+UseConcMarkSweepGC -XX:+UseTLAB -XX:NewSize=128m -XX:MaxNewSize=128m > -XX:MaxTenuringThreshold=0 -XX:SurvivorRatio=1024 > -XX:+UseCMSInitiatingOccupancyOnly -XX:CMSInitiatingOccupancyFraction=60 > -XX:+DisableExplicitGC -DIGNITE_H2_DEBUG_CONSOLE=true"/ > > thanks > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5240.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov
