Hi Neeraj, Try to change join order and enable option SqlFieldsQuery.enforceJoinOrder(true). Sometimes, changing join order can significantly improve performance.
On Fri, Jul 7, 2017 at 9:20 AM, neerajbhatt <[email protected]> wrote: > explain plan without order by > > > FROM ITEMCACHE.ITEM T__Z0 > /* ITEMCACHE.ITEM_RATING_IDX: RATING = ?1 */ > /* WHERE (T__Z0.RATING = ?1) > AND ((T__Z0.DOWNLOADS = ?3) > AND (T__Z0.REVIEWS = ?2)) > */ > INNER JOIN IGPCACHE.RANK R__Z1 > /* IGPCACHE.RANK_UNIQUESKUID_IDX: UNIQUESKUID = T__Z0.UNIQUESKUID */ > ON 1=1 > WHERE (T__Z0.DOWNLOADS = ?3) > AND ((T__Z0.REVIEWS = ?2) > AND ((T__Z0.RATING = ?1) > AND (T__Z0.UNIQUESKUID = R__Z1.UNIQUESKUID))) > LIMIT 10 > SELECT > __C0_0 AS _VAL > FROM PUBLIC.__T0 > /* IGPCACHE.merge_scan */ > LIMIT 10 > > > > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/slow-performance-when-using-order- > by-clause-tp14389p14470.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Andrey V. Mashenkov
