Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-26 : 23:20:55
|
ANDRES writes "i have configured a link to an oracle 7.3.4 server on a microsoft SQL 7.0 SP2 Server.
when i try to run the following query
SELECT CONTACT_FIRST_NAME,CONTACT_PATERNAL_NAME,CONTACT_CITY,CONTACT_STATE
FROM TMK..GUIDEMKT.TMK_INTERNET
WHERE CUST_ID='56812403'
the execution time is equal to 3 sconds.
if i change the value of Cust_id and make a variable decalration as follow
DECLARE @CLIENT_ID NVARCHAR(15)
SELECT @CLIENT_ID="56812403"
SELECT CONTACT_FIRST_NAME,CONTACT_PATERNAL_NAME,CONTACT_CITY,CONTACT_STATE
FROM TMK..GUIDEMKT.TMK_INTERNET
WHERE CUST_ID=@CLIENT_ID
The execution time for this query is equal to 4 minutes.
So, what's wrong with this query the properties for the field cust_id in the oracle database are the same varchar(15).
please can u help me.??
thanks for oyur collaboration." |
|
|
|
|
|
linked server