Prasad, 1. Yes, you will always see it in the execution plan because there are always two stages. Of course, if only one server node participates in the execution, the reduce stage is effectively no-op.
2. Yes, you need to put the annotation to make sure you can access it from queries. I would recommend you to treat it in the same way as any other SQL field. 3. The issue here is that you do not join by affinity key, but by user ID. This is a non-collocated join, so it can't be executed on a single node in the first place. I believe you should revisit your collocation strategy here. 4. The fact that it exists does not mean it would be used. I think you should fix the point #3 above before diving into further optimizations. -Val -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
