If collocation doesn't work, you should get incorrect results unless you enabled distributed joins (which you should not do if you're not going to utilize them).
Performance depends on many factors, number of entries for example. Regardless of what you do, you will scan the portion of Product table that satisfies the condition. Several things you can try: - use group index with both serialnumber and status field - move the condition to subquery - run with more nodes and check if the query scales -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Complex-queries-tp9626p9764.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
