I am using the Oracle JDBC drivers (latest) and calling the getImportedKeys() method of the OracleDatabaseMetaData class. But the performance is pathetic. could anybody suuggest me the way out. How can I optimize the query that is called from the method. or there is any other bottleneck, that I can look for.
Same problem with the getVersionColumns() method also.
I don't have the access to the DB configuration files. I mean my application can not optimize the performance parameters of the Database. All that I can do is, optimize the code of my application and the JDBC driver. So i m stuck. plz help.