ALSO_DB
asked on
SQL Server Linked Oracle Server
I have in my SQL environment a linked Oracle Server.
If I run a query against my linked Oracle Server the query doesn't use the Oracle Indexes. So the duration of the query tooks very long. On the Oracle server direct the Query took only seconds.
How could I made the right setup?
If I run a query against my linked Oracle Server the query doesn't use the Oracle Indexes. So the duration of the query tooks very long. On the Oracle server direct the Query took only seconds.
How could I made the right setup?
no matter you are executing query from linked server or directly from oracle server, Index is going to be used I guess. Network may be culprit in your case.
ASKER
the network isnt the culpirt!!!!!
ASKER
I looked with the oracle analyser and saw that sql made a full table scan!
See if the attached webpage helps. Seems like there is a bug.
Please change the extension to .htm after you have downloaded the file.
P.
How-Improve-Linked-Server-Perfro.txt
Please change the extension to .htm after you have downloaded the file.
P.
How-Improve-Linked-Server-Perfro.txt
Hi ALSO_DB,
how are you doing
try check the following in the Linked server setup for Oracle Provider for OLE DB
"Dynamic Parameters"
"Allow InProcess"
thanks
how are you doing
try check the following in the Linked server setup for Oracle Provider for OLE DB
"Dynamic Parameters"
"Allow InProcess"
thanks
ASKER
Dear mSharfi
"Dynamic Parameters" and "Allow InProcess" activated, but still slow like a snake...
"Dynamic Parameters" and "Allow InProcess" activated, but still slow like a snake...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.