ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexei Scherbakov <alexey.scherbak...@gmail.com>
Subject Re: Multiple column filtering and sorting in Apache Ignite
Date Wed, 22 Jun 2016 10:55:52 GMT
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.technology@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

Mime
View raw message