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 <[email protected]>: > 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
