When you perform update statistics on a remote server proxy table, if the relevant tables, index and column statistics are available, the table catalogs are imported to the local systabstats and sysstatistics.
By default, update statistics for proxy tables always attempts to import the required statistics data. But when the statistics data is unavailable or incomplete on the remote table, Component Integration Services (CIS) reverts to the prior mechanism of gathering statistic data.
You can also force CIS to revert to the prior mechanism of gathering statistic data by turning on Traceflag 11229. This allows you to obtain all data from the database, then calculating the statistics.
This is the behavior if update statistics has
not been run on the remote tables and there are no statistics available.
