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 <neerajbhatt2...@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