Accessing Corba through ODBC with ORACLE

[Quoted] We have a performance problem with Oracle accessing a Corba datasource that we are exposing through ODBC. When we do a Join between a native Oracle table and the Corba data source the optimizer chooses a merge join, thus pulling all the records from the Corba datasource. What we would like is an inner loop join, where the keys from the native Oracle [Quoted] table are passed to the Corba data source through ODBC.

We have described to the Oracle Open gateway the number of rows in our Corba data source (three million), the key (which is the attribute we are joining on) and the description of all the other attributes. Is there a way we can persuade Oracle to pass to our ODBC driver (that we are writing with ATI's ODBC SDK) a query such as

select * from CORBA_SOURCE
where CORBA_KEY in (k1, k2, ..., kn)

where k1, k2,..., kn are the join values from the native Oracle table?

Amalio
amalio_escobar_at_groton.pfizer.com Received on Tue Dec 05 2000 - 15:07:35 CET