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))

Reply via email to