Help a newbie with TKPROF output
Hi!
I have this query which takes over 1.5 minutes to complete. Is there anything I can do to make it go faster?
TASK_LOG have up to date statistics and have around 700 000 rows and RFM_ROLE_TASK_STORER only 200.
What to do?
SELECT *
FROM
TASK_LOG WHERE EXISTS (SELECT * FROM RFM_ROLE_TASK_STORER WHERE USER_ROLE_ID
= :B4 AND (STORER_ID = TASK_LOG.STORER_ID OR STORER_ID ='#ALL#') AND
(TASK_TYPE = TASK_LOG.TASK_TYPE OR TASK_TYPE ='#ALL#')) AND NVL2(:B3 ,
PICKLIST_GROUP_NO, -1) = NVL(:B3 , -1) AND NVL2(:B2 , TASK_TYPE, '¤') =
I have this query which takes over 1.5 minutes to complete. Is there anything I can do to make it go faster?
TASK_LOG have up to date statistics and have around 700 000 rows and RFM_ROLE_TASK_STORER only 200.
What to do?
SELECT *
FROM
TASK_LOG WHERE EXISTS (SELECT * FROM RFM_ROLE_TASK_STORER WHERE USER_ROLE_ID
= :B4 AND (STORER_ID = TASK_LOG.STORER_ID OR STORER_ID ='#ALL#') AND
(TASK_TYPE = TASK_LOG.TASK_TYPE OR TASK_TYPE ='#ALL#')) AND NVL2(:B3 ,
PICKLIST_GROUP_NO, -1) = NVL(:B3 , -1) AND NVL2(:B2 , TASK_TYPE, '¤') =
0