I have a question relating to job performance, one of the job is doing a normal lookup directly from the oracle table to retrieve ID, there are over 9 million records in the table and this lookup causes the performance to decrease.
how can i increase the efficiency of this job?
Thanks
Performance Tuning
Moderators: chulett, rschirm, roy
Re: Performance Tuning
Yes...If lookup isn't upto what you look for, go with the JOIN.attu wrote:I have a question relating to job performance, one of the job is doing a normal lookup directly from the oracle table to retrieve ID, there are over 9 million records in the table and this lookup causes the performance to decrease.
how can i increase the efficiency of this job?
Thanks
Also instead of directly lookup on Oracle table, you can try dumping the oracle table first, and then Join with this dumped file [if the table is more of a static one]