阅读背景:

从不同服务器中的链接表加入时,MS Access的性能如何?

来源:互联网 

If I have an MS Access database with linked tables from two different database servers (say one table from an SQL Server db and one from an Oracle db) and I write a query which JOINs those two tables, how will Access (or the Jet engine, I guess?) handle this query? Will it issue some SELECTs on each table first to get the fields I'm JOINing on, figurre out which rows match, then issue more SELECTs for those rows?If I have an MS Access database with linked tab




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: