Outer join causes much slower performance [message #558835] |
Tue, 26 June 2012 15:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/ab64ead89429d23ed1ab1e6b6839198a?s=64&d=mm&r=g) |
projecttoday
Messages: 2 Registered: June 2012
|
Junior Member |
|
|
Not sure if anybody can help me with this because I'm not using PL/SQL but maybe somebody can point me in the right direction. I have an Access database with some tables in it that are linked to an Oracle database. I am running queries on these linked tables in the Access version of SQL, not pass through. I have some queries with inner joins in them but if I change them to an outer join which I need to have in case a lookup record is missing the performance slows dramatically. Any idea why this is and what I can do about it? The queries are used to create Access tables. I tried using a pass-through but that was slow also. I have no control over or direct access to the Oracle database.
|
|
|
|
|
|