ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jan.swaelens" <jan.swael...@sofico.be>
Subject Re: Unexpected performance issue with SQL query followed by error
Date Mon, 09 May 2016 07:09:33 GMT
Thanks,

It indeed looks like its not using indexes. I'll have a go with it and let
you know where I ended up.

SELECT DISTINCT
    ACTIVITY0.ACTIVITY_ID AS __C0,
    ACTIVITY0.SEQUENCENR AS __C1,
    ACTIVITY0.NAME_MLID AS __C2,
    ACTIVITY0.NAME AS __C3,
    ACTIVITY0.DESCRIPTION_MLID AS __C4,
    ACTIVITY0.DESCRIPTION AS __C5,
    ACTIVITY0.DURATIONUNIT_ENUMID AS __C6,
    ACTIVITY0.DURATION AS __C7,
    ACTIVITY0.REQUIRED AS __C8,
    ACTIVITY0.PREDECESSORTYPE_ENUMID AS __C9,
    ACTIVITY0.SUCCESSORTYPE_ENUMID AS __C10,
    ACTIVITY0.REMOVEFROMWORKLIST AS __C11,
    ACTIVITY0.LASTACTIVITY_ID AS __C12,
    ACTIVITY0.LIFECYCLEREPORTING AS __C13,
    ACTIVITY0.DUEDATE AS __C14,
    ACTIVITY0.PRIORITY_ENUMID AS __C15,
    ACTIVITY0.NOTIFY AS __C16,
    ACTIVITY0.TIMESTAMP AS __C17,
    ACTIVITY0.ACTIVITYTYPE_ID AS __C18,
    ACTIVITY0.CONTAINER_ID AS __C19,
    ACTIVITY0.REALIZATION_ID AS __C20,
    ACTIVITY0.KERNEL_ID AS __C21,
    ACTIVITY0.SYSREPOPERATION_ID AS __C22
FROM "Activity".ACTIVITY ACTIVITY0
    /* "Activity".FI_ACTIVITY2: KERNEL_ID IS NULL */
    /* WHERE (ACTIVITY0.KERNEL_ID IS NULL)
        AND (ACTIVITY0.REALIZATION_ID IS NULL)
    */
LEFT OUTER JOIN "Activity".ACTIVITYHISTORY ACTIVITYHISTORY0
    /* "Activity".PK_ACTIVITYHISTORY: ACTIVITYHISTORY_ID =
ACTIVITY0.LASTACTIVITY_ID */
    ON ACTIVITYHISTORY0.ACTIVITYHISTORY_ID = ACTIVITY0.LASTACTIVITY_ID
LEFT OUTER JOIN "Activity".ACTIVITYUSERACCOUNTROLE ACTIVITYUSERACCOUNTROLE0
    /* "Activity".ACTIVITYUSERACCOUNTROLE.__SCAN_ */
    ON ACTIVITYUSERACCOUNTROLE0.ACTIVITY_ID = ACTIVITY0.ACTIVITY_ID
LEFT OUTER JOIN "Activity".ACTIVITYHISTORYUSERACCOUNT
ACTIVITYHISTORYUSERACCOUNT0
    /* "Activity".ACTIVITYHISTORYUSERACCOUNT.__SCAN_ */
    ON ACTIVITYHISTORYUSERACCOUNT0.ACTIVITYHISTORY_ID =
ACTIVITYHISTORY0.ACTIVITYHISTORY_ID
WHERE ((NOT (ACTIVITYHISTORY0.ACTIVITYSTATE_ENUMID IN(37, 30, 463, 33,
464)))
    AND ((ACTIVITY0.KERNEL_ID IS NULL)
    AND (ACTIVITY0.REALIZATION_ID IS NULL)))
    AND ((ACTIVITYHISTORYUSERACCOUNT0.USERACCOUNT_ID = 600301)
    OR ((ACTIVITYUSERACCOUNTROLE0.USERACCOUNTROLE_ID IN(1, 3))
    AND ((ACTIVITY0.REMOVEFROMWORKLIST = 0)
    OR (ACTIVITYHISTORYUSERACCOUNT0.USERACCOUNT_ID IS NULL))))
SELECT DISTINCT
    __C0 AS ACTIVITY_ID,
    __C1 AS SEQUENCENR,
    __C2 AS NAME_MLID,
    __C3 AS NAME,
    __C4 AS DESCRIPTION_MLID,
    __C5 AS DESCRIPTION,
    __C6 AS DURATIONUNIT_ENUMID,
    __C7 AS DURATION,
    __C8 AS REQUIRED,
    __C9 AS PREDECESSORTYPE_ENUMID,
    __C10 AS SUCCESSORTYPE_ENUMID,
    __C11 AS REMOVEFROMWORKLIST,
    __C12 AS LASTACTIVITY_ID,
    __C13 AS LIFECYCLEREPORTING,
    __C14 AS DUEDATE,
    __C15 AS PRIORITY_ENUMID,
    __C16 AS NOTIFY,
    __C17 AS TIMESTAMP,
    __C18 AS ACTIVITYTYPE_ID,
    __C19 AS CONTAINER_ID,
    __C20 AS REALIZATION_ID,
    __C21 AS KERNEL_ID,
    __C22 AS SYSREPOPERATION_ID
FROM PUBLIC.__T0
    /* "Activity"."merge_scan" */

br
jan



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p4845.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message