CONNECT » ODBC Engine's Documentation states in section "Accessing specified views"
that when Creating CONNECT - ODBC Tables which access to views in the foreign server, WHERE clause is performed locally, instead of in the foreing server accessed via ODBC (As it would be done by default).
Therefore, I would like to suggest that WHERE is also performed in the "Foreing Server", as it allows:
- To reduce the data which is sent by the data source, preventing to have to send the hole table though the network for being able to filter it.
An example would be as follows:
Maybe this could be achieved by creating a "derived table" in the Foreing Server (which contains the View), to which the WHERE clause is applied afterwards.
Hope my suggestion is useful!