ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrey Mashenkov <andrey.mashen...@gmail.com>
Subject Re: query performance degrade when adding a filter criteria (order by)
Date Tue, 11 Jul 2017 12:19:47 GMT
Hi,

Possibly, H2 planned use different indices for these queries.
Try to use HINTS [1] if it is impossible to make H2 use proper index
without breaking other queries.

[1]
https://apacheignite.readme.io/docs/sql-performance-and-debugging#section-index-hints

On Tue, Jul 11, 2017 at 2:47 PM, neerajbhatt <neerajbhatt2000@gmail.com>
wrote:

> Also field a in A_CACHE.Rank (r) is indexed
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/query-performance-degrade-when-
> adding-a-filter-criteria-order-by-tp14624p14625.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Best regards,
Andrey V. Mashenkov

Mime
View raw message