I am using an Access front end to allow users to append records to an Oracle table through ODBC.
I am suprised by how slow the query runs -- it takes over 5 minutes append 2000 records. I am not doing anything fancy in the query, it is a simple INSERT INTO (SELECT FROM).
Does anyone have any tips for speeding up an append query? I have indexes on the same fields in each table, and that doesn't seemed to help.