When querying a view over a linked server, the row estimates are incorrect and set to be 10,000 rows. The credentials used for the linked server make no difference. This can lead to inefficient execution plans.This is using SQL Server 2012, SP1.A reproduction script is included in the details below.
Operating System Language
Steps to Reproduce