Does the server have access to the linked server's statistics? http://www.benjaminnevarez.com/2011/05/optimizer-statistics-on-linked-servers/ http://www.benjam

Does the server have access to the linked server's statistics? http://www.benjaminnevarez.com/2011/05/optimizer-statistics-on-linked-servers/ http://www.benjaminnevarez.com/2011/05/optimizer-statistics-... > To create the best query plans when you are using a table on a linked server, the query processor must have data distribution statistics from the linked server. Users that have limited permissions on any columns of the table might not have sufficient permissions to obtain all the useful statistics, and might receive a less efficient query plan and experience poor performance