If you create an index on (A,B,C), SQL queries for all three variants you note should work and use the index.
Having said that, “returning a huge number of rows” doesn’t seem like a good usage pattern with Ignite. You might be better distributing your query around the cluster rather than returning lots of records to a client. And depending on what proportion of records you’re returning, a scan query may be more efficient. > On 30 Jan 2020, at 13:32, Tunas <[email protected]> wrote: > > I have key composed of "A"+"B"+"C"+Id. > > I want to do search by "ABC*" or"AB*" or "A*". > Require very efficient query as i am fetching huge number of rows from cache > based on above query. > Also my values are serialized customize big user objects? > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/
