ODBC behaves differently between Enterprise and Standard

I have run into a problem with an MS Access based query that behaves differently base on whether a table attachment was created against an Enterprise Edition server or Standard Edition server.

Here are the environments;

Identical database on Two Servers;
Oracle 8.1.7 Enterprise Edition;
And
Oracle 8.1.7 Standard Edition

Both on Windows 2000 server

Client;
8.1.7 client and the 8.1.7.0.0 ODBC driver on Windows 2000 pro MS Access 97

I am running an Access query that contains two native access tables and an ODBC attached Oracle table. The primary Access table is outer joined with a secondary Access table and inner joined with an Oracle table. The purpose of the query is to pull details out of a large Oracle table for records that are missing in the second Access table.

If I create the ODBC table link to the to Enterprise Edition server, it causes a full table scan when I run the query. If I create the link to Standard Edition server it uses an index.

Does anyone have any ideas why this is happening? Received on Sun Oct 20 2002 - 09:48:11 CDT