Hi All Our below query is working fine SELECT r.uniqueSkuId FROM A_CACHE.Rank as r, B_CACHE.Item as T WHERE T.id = r.id AND T.b=? AND T.c=? AND T.d=? order by r.rank desc limit 3
but when we add additional criteria (r.a=?) as below the time increase from 10 ms to ~500 ms SELECT 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-tp14624.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.