November 25, 2010 at 1:49 pm
HI,
I'va a Linked Server from SQL server 2005 to Oracle.
The big problem is the running query time: very very slow with four name way... ( select from two table join with a PK about 5 mins to retriev data )
I tried to use OPENQUERY but I think it isn't right solution because with this function is not possible use parameters and my stored procedures have to perform filtering with parameters
Is there some faster way ?
Second problem : I run a Openquery using four name with "select ...order by DT_INS" where DT_INS is a Date field.
The query run ok.
If I try to run
select * from openquery(linkedserver,'select * from tableOracle where DT_INS >=''20101001''') order by DT_INS
Error "Cannot fetch row....."
Why?
Many thanks
( sorry for my English )
November 26, 2010 at 9:18 am
Gianni Ottimista (11/25/2010)
HI,I'va a Linked Server from SQL server 2005 to Oracle.
The big problem is the running query time: very very slow with four name way... ( select from two table join with a PK about 5 mins to retriev data )
I tried to use OPENQUERY but I think it isn't right solution because with this function is not possible use parameters and my stored procedures have to perform filtering with parameters
Is there some faster way ?
Second problem : I run a Openquery using four name with "select ...order by DT_INS" where DT_INS is a Date field.
The query run ok.
If I try to run
select * from openquery(linkedserver,'select * from tableOracle where DT_INS >=''20101001''') order by DT_INS
Error "Cannot fetch row....."
Why?
Many thanks
( sorry for my English )
The OPENQUERY method should work.
Try to use Oracle syntax in the OPENQUERY and dump the results to a SQL server temp table, then do the ordering.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply