I am using SQL Server 2000. I set up a linked server against a Oracle Server. How do I speed up this Linked server query against a Oracle server? Their are 2 milion records which take approximately 30 minutes. I would appreciate anyones's help. Here is the code.
/* DOB */
/* Insert new records */
PRINT 'Inserting new DOBs.'
INSERT CALPHOTO.dbo.DOB
(
FCN,
ORI_OWNER,
OCA,
TIMESTAMP,
CP_FCN,
CP_TIME
)
SELECT
left(FCN,13),
left(ORI_OWNER,9),
left(OCA,20),
CREATED_TIMESTAMP,
'LASD' + left(FCN,13),
getdate()
FROM openquery(LOS_ANGELES, 'SELECT /*+ RULE */ fcn, ORI_OWNER, OCA, CREATED_TIMESTAMP from IWS.CAL_DOB')
/* DOB */
/* Insert new records */
PRINT 'Inserting new DOBs.'
INSERT CALPHOTO.dbo.DOB
(
FCN,
ORI_OWNER,
OCA,
TIMESTAMP,
CP_FCN,
CP_TIME
)
SELECT
left(FCN,13),
left(ORI_OWNER,9),
left(OCA,20),
CREATED_TIMESTAMP,
'LASD' + left(FCN,13),
getdate()
FROM openquery(LOS_ANGELES, 'SELECT /*+ RULE */ fcn, ORI_OWNER, OCA, CREATED_TIMESTAMP from IWS.CAL_DOB')