I am having an sql query which reads data from Oracle four tables by performing a join on them. The number of rows in each table is in millions. This query gets fired from a tool which is written in C++. The data retrieved from this query will be used to reconcile in memory data base(separate DataBase).
The performance of tool is getting degraded . Its taking lot of time because of the sheer number of records in each table and also because of the join operation,
We thought that we will remove the join operation and will get all the records in memory and then do the reconcilation.
Please suggest any other ideas or tell us whether we are right in taking the data in memory and then do the reconcilation.
Thanks in advance