Popular White Paper On This Topic

Can you take a look at the query that is being used to retrieve the records
from source.
1. Validate whether you have used the complete key rather than partial keys.
2. Check any oracle functions(costly) ones are used, example - TO_UPPER,
IN. If so remove them and give exact string. 3.do an explain plan for the input query and make sure you do not have any
cartesian joins.
4. If you could eliminate reading the complete table it will be good.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.