Need To Tune Query Fired On Exact Match Criteria
Last updated on JUNE 03, 2015
Applies to:Siebel Campaigns - Version 8.0  and later
Information in this document applies to any platform.
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 :
,S_COMM_IMPT.ROW_ID AS STAGERID
UPPER(S_CONTACT.EMAIL_ADDR)=UPPER(S_COMM_IMPT.CON_EMAIL_ADDR) AND CONTACT_ID
AND IMPRT_TSK_ID = '1-P2Q35'
AND IMPRTRUN_SEQ_NUM ='1-P2C7N'
AND IMPTPROC_BATCH_NUM = '1-P2C7N0'
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