ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lucky <wanxing...@163.com>
Subject Re:Re: Re: Re: Re: Re: Re: Re:Poor performance select query with jdbc thin mode
Date Wed, 06 Dec 2017 09:06:25 GMT
explain :




SELECT
    T0__Z0.FID AS __C0_0,
    T0__Z0.FCUSTOMERGROUPSTANDARDID AS __C0_1,
    T0__Z0.FCUSTOMERGROUPID AS __C0_2,
    T0__Z0.FCUSTOMERID AS __C0_3,
    T0__Z0.FCUSTOMERGROUPFULLNAME AS __C0_4
FROM "csspGroupStandardCache".CSSPGROUPSTANDARD T1__Z1
    /* "csspGroupStandardCache".CSSPGROUPSTANDARD_FID_IDX: FID = '00000000-0000-0000-0000-000000000002BC122A7F'
*/
    /* WHERE T1__Z1.FID = '00000000-0000-0000-0000-000000000002BC122A7F'
    */
INNER JOIN "customerGroupDetailCache".CUSTOMERGROUPDETAIL T0__Z0
    /* batched:broadcast "customerGroupDetailCache".CUSTOMERGROUPDETAIL_FCUSTOMERGROUPSTANDARDID_IDX:
FCUSTOMERGROUPSTANDARDID = T1__Z1.FID */
    ON 1=1
    /* WHERE T0__Z0.FCUSTOMERGROUPSTANDARDID = T1__Z1.FID
    */
INNER JOIN "customerCache".CUSTOMERIGNITEINFO T3__Z2
    /* batched:broadcast "customerCache".CUSTOMERIGNITEINFO_FID_IDX: FID = '3NsAAABI7bq/DAQO'
        AND FID = T0__Z0.FCUSTOMERID
     */
    ON 1=1
WHERE ((T3__Z2.FID = '3NsAAABI7bq/DAQO')
    AND (T1__Z1.FID = '00000000-0000-0000-0000-000000000002BC122A7F'))
    AND ((T0__Z0.FCUSTOMERID = T3__Z2.FID)
    AND (T0__Z0.FCUSTOMERGROUPSTANDARDID = T1__Z1.FID))
Mime
View raw message