What happens, if I execute the following query in SQL Server?
Does SQL Server retrieve all records from Progress and then executes the where clause?
PS: LinkedServerName.Catalog1.PUB.Table1 is a table in Progress DB and AnotherTableInSQLServer is a table in SQL Server.
Code:
select Col1, Col2, sum(Col3) as Col3Sum
from LinkedServerName.Catalog1.PUB.Table1
where Col1 in (select Col1 from AnotherTableInSQLServer)
group by Col1, Col2
Does SQL Server retrieve all records from Progress and then executes the where clause?
PS: LinkedServerName.Catalog1.PUB.Table1 is a table in Progress DB and AnotherTableInSQLServer is a table in SQL Server.