Hi Ray, You are right, currently complex PK can't be used as index and performance for your query are bad due to full scan. After IGNITE-8386 <https://issues.apache.org/jira/browse/IGNITE-8386> will be merged the same query start use PK index.
вт, 18 сент. 2018 г. в 8:16, Ray <ray...@cisco.com>: > 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/ > -- Живи с улыбкой! :D