Query executed through a heterogeneous gateway to the MS SQL database

exdevn

Member
Hello!
A query is executed through a heterogeneous gateway to the MS SQL database:
select "column", "column", "column", "column" ... etc from dbo.table@link_name where "column" = value;
If you run this request once, then this request will be executed, and if you run it the second time or the third, it is already running:
select * from dbo.table@link_name;
full scan? why?
I do not have a full scan request in the tab; tell me why this is happening?
Thanks!
 
Last edited:
Back
Top