Thanks, Added the code and executed the following:
EXPLAIN ANALYZE SELECT DISTINCT * FROM "Activity".activity activity0 LEFT OUTER JOIN "Activity".activityuseraccountrole activityuseraccountrole0 ON activityuseraccountrole0.activity_Id = activity0.activity_Id AND activityuseraccountrole0.useraccountrole_Id IN (1, 3) This also keeps running until eternity, well at least for 30 minutes after which I give up. Should I wait it out or does it make sense to add a clause to limit the data? best regards jan -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5194.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
