Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Does the server have access to the linked server's statistics?

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



Is there a good reason for this? I can't think of one.

I think a lot of such nonsense is going to go away very soon.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: