See SQL statement #1 below. When I run only the SELECT portion of the statement, the run time is acceptable (1 mins., 57 secs.).

However, when I add the INSERT, the run time is absolutely unacceptable (38 mins., 5 secs.).

Adding the DRIVING_SITE hint had absolutely no effect. I also tried adding a "COLLOCATED INLINE VIEW" which had no effect, see SQL statement #2 below.

Changing the order of the optimizer hints also has little, if any, effect.

Adding temp tables or views on the remote database is not an option as it is a production database and I do not have CREATE privilege.

Does anybody have any suggestions?????

-- SQL Statement #1
INSERT INTO TEMP.T_LIAR_ADDRESS
*SELECT /*+ INDEX(AR,PK_T_LIAR_ADDRESS) *
DRIVING_SITE(AR) */
******* AR.*,
******* TO_DATE('2006-07-15', 'yyyy-mm-dd'),
******* SYSDATE
*FROM DBO.T_LIAR_ADDRESS@LIFECAD.SBL.COM AR
*WHERE AR.ar_address_id IN (SELECT DISTINCT
********************************** PR.pr_address_id
*************************** FROM DBO.T_LIPR_POLICY_ROLE@LIFECAD.SBL.COM PR
*************************** WHERE PR.tstamp > (SELECT DT.CMP_DATE
********************************************** FROM CORE.DT_COMPDATE@LIFECAD.SBL.COM DT)) OR
****** AR.tstamp > (SELECT DT.CMP_DATE
******************* FROM CORE.DT_COMPDATE@LIFECAD.SBL.COM DT)

-- SQL Statement #2
INSERT INTO TEMP.T_LIAR_ADDRESS
SELECT *
FROM (SELECT /*+ INDEX(AR,PK_T_LIAR_ADDRESS)
DRIVING_SITE(AR) */
AR.*,
TO_DATE('2006-07-15', 'yyyy-mm-dd'),
SYSDATE
FROM DBO.T_LIAR_ADDRESS@LIFECAD.SBL.COM AR
WHERE AR.ar_address_id IN (SELECT DISTINCT
PR.pr_address_id
FROM DBO.T_LIPR_POLICY_ROLE@LIFECAD.SBL.COM PR
WHERE PR.tstamp > (SELECT DT.CMP_DATE
FROM CORE.DT_COMPDATE@LIFECAD.SBL.COM DT)) OR
AR.tstamp > (SELECT DT.CMP_DATE
FROM CORE.DT_COMPDATE@LIFECAD.SBL.COM DT)) V