Alexey, Definitely! Please go ahead.
Anil, If you do not use indexes, then sorting will be performed each time. Sorry. >From your pattern I suspect that you output the result set into some UI table with sortable columns, am I right? Sergi 2017-04-04 13:54 GMT+03:00 Anil <[email protected]>: > 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 >>> >>> >> >
