Thanks Alexei, for Ignite.NET the link will be https://apacheignite-net.readme.io/docs/sql-queries#configuring-sql-indexes-using-queryentity
On Wed, Jun 22, 2016 at 1:55 PM, Alexei Scherbakov < alexey.scherbak...@gmail.com> wrote: > Mrinal, > > You must create group index for query like: > ordery by field1 asc, field2 desc > > You can define such index using annotations or QueryEntry [1] > > I prefer QueryEntry for defining complex indexes. > > Don't forget to check actual index usage by issuing EXPLAIN command from > the H2 console or code. > > [1] > https://apacheignite.readme.io/docs/sql-queries#configuring-sql-indexes-using-queryentity > > > > 2016-06-22 13:08 GMT+03:00 mrinalkamboj <mrinal.technol...@gmail.com>: > >> Hello Alexei, >> >> This operation is via user input, we don't directly control it. It may not >> be efficient, but still user can do the operation. >> >> Thanks, >> >> Mrinal >> >> >> >> -- >> View this message in context: >> http://apache-ignite-users.70518.x6.nabble.com/Multiple-column-filtering-and-sorting-in-Apache-Ignite-tp5783p5788.html >> Sent from the Apache Ignite Users mailing list archive at Nabble.com. >> > > > > -- > > Best regards, > Alexei Scherbakov >