Hi Sergi, Thanks for the response.
I have around 70 columns and support sorting on many columns. group index is not suitable in my case. Do you have any other suggestions ? To some extent https://issues.apache.org/jira/browse/IGNITE-3013 improves the response time. Thanks On 4 April 2017 at 15:28, Sergi Vladykin <[email protected]> wrote: > You should create a group index on (A, B) and rewrite the query the > following way: > > select * from Test where A = '<something>' order by A, B > > Semantically it will be the same, but it will use index (A, B) for search > and sorting. > > Sergi > > 2017-04-04 12:18 GMT+03:00 Anil <[email protected]>: > >> HI, >> >> i have created a table with columns A and B. A is indexed column. and use >> following queries >> >> 1. select * from Test where A = '<something>' >> 2. select * from Test where A = '<something>' order by B >> >> #1 is fast as it uses default sorting of indexed column A. But #2 is slow. >> >> Do you think creating index on B will speed up #2 query ? i tried that as >> well and no luck. >> >> are there any ways to improve the performance of #2 ? please advise. >> >> Thanks >> >> >
