Outer join causes much slower performance [message #558835] |
Tue, 26 June 2012 15:37 |
|
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.
|
|
|
|
|
|