Access and Linked tables to Oracle

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In the past I created an Access database front end for our end users
for the purposes of querying our Oracle data. I noticed that in this
older Access database that one of our large Oracle tables was linked
without an index (primary key in this case).

The interesting part of this issue is that this older Access database
returns results from a query against this large Oracle table very, very
quickly. Something around 2 seconds if Oracle has cached the query
results and 8 seconds if it has not.

My primary issue now is that when I refresh the linked tables an index
is getting defined for the primary key in the large Oracle table. What
this has done is cause this query to take up to 2 1/2 minutes to return
the same results!

I am not able to delete the primary key (index) from the linked table
so I am not able to test to see if removing it would make the refreshed
Access database respond in a more timely fashion.

Does anyone know a way around the index properties screen in Access in
order to make this change?

Is there way way to prevent the defining of indexes when
programatically creating these linked tables?

Any suggestions would be greatly appreciated!

Sincerely,

Tim Frawley

.

Relevant Pages

  • Re: oracle and exporting data for a .mdb file
    ... >still needs to go the access database where it IS EXPECTING a .mdb file. ... as this will be considered a change request and more ... Can oracle do it, and where can I find out how to do ...
    (comp.unix.programmer)
  • Re: Querying two separate connections
    ... Using OLEDB is much quicker and I was ... Oracle table with Delphi by itself? ... > Access had the capability to link a table into and Access database from ... > use it in a query as if it was an Access table. ...
    (borland.public.delphi.database.ado)
  • Re: Top Select returning Ties
    ... is a small Access database ... Please find the time to help me out - I have the following query: ... Primary is an auto number feild that i used as the primary key ... My issue is I only need the top 10 Total GA, regardless of ties - there ...
    (microsoft.public.access.queries)
  • Re: Copy selected files
    ... within an access database I store the filelocation, ... Using a query I select some of those records (containing the primary key of ... Use command FileCopyto copy images. ...
    (microsoft.public.access.modulesdaovba)
  • Re: oracle and exporting data for a .mdb file
    ... > still needs to go the access database where it IS EXPECTING a .mdb file. ... Can oracle do it, and where can I find out how to ... But, given your constraints, what I would do is connect a Windows machine ...
    (comp.unix.programmer)