And it makes sense as the query will "travel" througth the net and retrieve the data from the original database each time you query the table (will not store data to index).
No, you will get an error:
Hope that helps. Good luck!
What you can do is to use explain verbose to get the query that is being execute on the other side , and index the remote table accordingly .