ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pavel Tupitsyn <ptupit...@gridgain.com>
Subject Re: Multiple column filtering and sorting in Apache Ignite
Date Wed, 22 Jun 2016 11:01:37 GMT
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.scherbakoff@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.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