Does DTS estimate cardinality?

Ryan Daulton 1 Reputation point
2022-03-17T21:14:42.987+00:00

Does DTC estimate cardinality when Joining tables from 2 different servers so that the work is evenly distributed to those 2 servers based on cardinality?

We're using SSMS 2016.

The goal is to optimize transactions between the OLTP server and source servers. The source servers have indexes applied that I want to leverage during processing for JOINS and WHERE clauses.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,895 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 102.3K Reputation points
    2022-03-17T22:09:57.313+00:00

    DTC just coordinates transactions and cannot even spell to opptimiizashon.

    The optimization is performed by the SQL Server instance where the query originates. To be able to perform the optimization, it queries the remote data source for information needed for optimization: that is table definition, available indexes and statistics.

    0 comments No comments