How much data do you have in both tables? 30 minutes is too long even for full scan in memory.
Please run EXPLAIN ANALYZE SELECT DISTINCT * FROM "Activity".activity activity0 EXPLAIN ANALYZE SELECT DISTINCT * FROM "Activity".activityuseraccountrole activityuseraccountrole0 WHERE activityuseraccountrole0.useraccountrole_Id IN (1, 3) Don't you forget to configure GC property, as discussed earlier in this topic ? Do you have any activity on cache while running the query ? 2016-05-25 16:48 GMT+03:00 jan.swaelens <[email protected]>: > 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. > -- Best regards, Alexei Scherbakov
