Hi Sergi,
If you do not use indexes, then sorting will be performed each time. Sorry. * - i cannot use group indexes that you suggested. But i am using individual indexes* >From your pattern I suspect that you output the result set into some UI table with sortable columns, am I right? - *Yes* :) Thanks On 4 April 2017 at 16:45, Sergi Vladykin <[email protected]> wrote: > 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 >>>> >>>> >>> >> >
