ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From neerajbhatt <neerajbhatt2...@gmail.com>
Subject Re: slow performance when using order by clause
Date Fri, 07 Jul 2017 06:20:55 GMT
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.

Mime
View raw message