Can you create an index on a foreign table?(外部表可以创建索引吗?)

  • 时间:
  • 浏览:0
  • 来源:uu快3下载网站_uu快3开户二维码

No, you will get an error:

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).

来自google搜索的一段回答

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 .