Re: Controlling disaggregation of JOIN query against linked (oracle) tables
Date: Wed, 31 Oct 2001 00:45:17 GMT
Message-ID: <xQHD7.1915$Fm5.1214497_at_news1.sttln1.wa.home.com>
Use pass though queries then it will happen on the Oracle side where it will
be much faster.
Jim
"Claus Gehner" <claus.gehner_at_wwireless.com> wrote in message
news:2f020e71.0110300931.78fbe8d2_at_posting.google.com...
> MS Access seems to have its own logic for disaggregating a multi-table
> JOIN against linked (Oracle) tables. Sometimes it sends the entire
> JOIN to the Oracle database to have the JOIN performed on the Oracle
> side, sometimes it disaggregates the JOIN query into multiple
> single-table queries to retrieve individual table rows and then
> perform the JOIN operation locally on MS Access.
> I have not been able to detect any regularity or rules for this
> behaviour.
> Is there any way of controlling MS Access behaviour in how it sends
> JOIN queries on linked tables to the remote database?
Received on Wed Oct 31 2001 - 01:45:17 CET