I have set up a linked server to an oracle DB to pull some data. However, when I run any query passing the pk of the row I am after all I can see in Oracle is the query doing a Full Table Scan.
SQL Server does not appear to be sending the where clause as part of the query to oracle but appears to be saying - give me all the data and I will filter on the where clause when it has all been returned.
Even adding an oracle hint into the query has no effect it continues to FTS.
Is there any way of forcing the full query to be sent to oracle.
Example query is
select *
from tab_1
where column_1 = 123456
column_1 is the PK in the oracle DB
Any help much appreciated.
Thanks
DBomrrsm
![[bandito]](/data/assets/smilies/bandito.gif "[bandito] [bandito]")
[blue]DBomrrsm[/blue]
[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
SQL Server does not appear to be sending the where clause as part of the query to oracle but appears to be saying - give me all the data and I will filter on the where clause when it has all been returned.
Even adding an oracle hint into the query has no effect it continues to FTS.
Is there any way of forcing the full query to be sent to oracle.
Example query is
select *
from tab_1
where column_1 = 123456
column_1 is the PK in the oracle DB
Any help much appreciated.
Thanks
DBomrrsm
[blue]DBomrrsm[/blue] [blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]
