List Management - Performance Issue
Last updated on AUGUST 20, 2017
Applies to:Siebel Marketing - Version 188.8.131.52  and later
Information in this document applies to any platform.
Where clause not getting generated for while adding a prospect to the list.
Steps to reproduce:-
Navigate to List Management > Prospects
Select a Prospect and click 'Add To List'
Select a List and click 'Ok'
The following sql is generated which has only outer joins in the where clause which makes the query expensive
SELECT /*+ ALL_ROWS */
T3.CON_PER_ID = T1.PAR_ROW_ID (+) AND
T3.PRSP_CON_PER_ID = T2.ROW_ID (+)
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