Share via

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.

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    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.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.