End App: MS ACCESS 2010.
Driver: Oracle ODBC 32 bit driver.
Database: Oracle 12.2.X.
We have created Oracle linked tables in MS Access 2010 and are facing performance issue every time when tables are queried or even just listed the tables.
Looking at the trace the query produced by the ODBC 32 bit driver, We feel query can be tuned to return the result set in sub seconds.
a. Is there a way we can alter ODBC's behavior of generating the queries that gets sent to Oracle.
b. Any parameter settings that can be used to help a.
c. Anything else that can help make the queries return result set .
Please note we can use Pass-Through queries but we don't want to control or write each of 1000's of scripts.
Appreciate your help
-SP