Need To Tune Query Fired On Exact Match Criteria (Doc ID 1083871.1)

Last updated on JUNE 03, 2015

Applies to:

Siebel Campaigns - Version 8.0 [20405] and later
Information in this document applies to any platform.

Symptoms

During execution of a List Import operation ( to import responses ) , 'Email Address' is selected as the field to do an exact match.

This causes a bad performance during execution of a SQL :

SELECT S_CONTACT.ROW_ID
,S_COMM_IMPT.ROW_ID AS STAGERID
FROM
   SIEBEL.S_CONTACT S_CONTACT
   ,SIEBEL.S_COMM_IMPT S_COMM_IMPT
WHERE
   UPPER(S_CONTACT.EMAIL_ADDR)=UPPER(S_COMM_IMPT.CON_EMAIL_ADDR) AND CONTACT_ID
IS NULL
AND IMPRT_TSK_ID = '1-P2Q35'
AND IMPRTRUN_SEQ_NUM ='1-P2C7N'
AND IMPTPROC_BATCH_NUM = '1-P2C7N0'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms