Querying Stretch Databases

When you query a Stretch Database, the SQL Server Database Engine runs the query against the local or remote database depending on data location. This is completely transparent to the database user. When you run a query that returns both local and remote data, you can see the Remote Query operator in the execution plan. The following query returns all rows from the stretch T1 table:

USE Mila; 
SELECT * FROM dbo.T1; 

As expected, it returns five rows:

id          c1                   c2
----------- -------------------- -----------------------
2           Manchester United    2016-06-02 00:00:00.000
4           Juventus Torino      2016-06-25 00:00:00.000
5           Red Star Belgrade    2016-06-25 00:00:00.000
1           Benfica Lisbon       2016-05-15 00:00:00.000
3           Rapid Vienna         2016-05-28 00:00:00.000

You are surely much more interested in how the execution plan looks. It is shown in Figure 6.19:

Figure 6.19: Execution plan for query...