Hi, The first SELECT here is the execution plan for the query that is executed on remote nodes, the second one is for the local query executed during the reduce step.
Remote query execution plan shows that the index is correctly used and the query will be executed in the fastest possible way. Since there are no aggregations in this particular query, the reduce step is trivial - result sets from remote nodes are simply merged into one. So execution plan actually doesn't show any useful information in this case. Makes sense? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Explain-the-h2-explain-tp1344p1346.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
