Tool used : TOAD Pro Edtion 3.6.
I am using Heterogeneous query for Joining the 4 tables. The 2 DBs are :
(2) ODBC Generic - Informatica
The records present in these tables are huge. Now while executing the simple DML queries after joining these tables taking a lot of time(almost 4-5hrs) . Could you please let me know whether there is any limitations with number of records that should be used in heterogeneous queries or do you have any other ways or setttings to change to optimize the queries so that the output will come faster.
Number of records present in the tables are below:
table-1 : 164168 records
table-2 : 1256526 records
table-3 : 4366394 records
table-4 : 6941 records