To answer my own question here, basically the index created on PK now is useless according to this ticket. https://issues.apache.org/jira/browse/IGNITE-8386
Ignite will perform a whole table scan when trying to execute the SQL query I posted above unless an index identical to PK is created manually. Please correct me if understand it wrong. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
