Re: query performance degrade when adding a filter criteria (order by)

Hi, Did you check execution plans? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/query-performance-degrade-when-adding-a-filter-criteria-order-by-tp14624p15023.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: query performance degrade when adding a filter criteria (order by)

, neerajbhatt 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

Re: query performance degrade when adding a filter criteria (order by)

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.

query performance degrade when adding a filter criteria (order by)

r.uniqueSkuId FROM A_CACHE.Rank as r, B_CACHE.Item as T WHERE T.id = r.id AND r.a=? AND T.b=? AND T.c=? AND T.d=? order by r.rank desc limit 3 Thanks -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/query-performance-degrade-when-adding-a-filter-criteria-order-by