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.
