As powerful as this technique might be, its utility is limited by the fact that we're using views to circumvent normal table access methods. This means our foreign table now has the same limitations as views. Unless the view is very simple-which would defeat the purpose of using a view like this-we cannot perform any of the following actions:
- We cannot insert into a foreign table view
- We cannot update records in a foreign table view
- We cannot delete from a foreign table view
However, there is one thing we can do with a foreign table view that we can't do with a local view. As foreign tables can be analyzed to gather statistics, we can analyze foreign table views as well. This produces local statistics that may include correlations ...
