Hi All
We are migrating our environment from 7.5.1 to 7.5.3 ,and database is upgraded from Oracle 9i to Oracle 10g.
Some of the jobs are getting hanged while updating in new environement (7.5.3 + 10g).After analysis with DBA Team,we come to know that jobs running on 7.5.3 ,are not using the oracle table indexes.
Does anybody know which is the DataStage parameter to be set,to make the job use oracle indexes?
Thanks for your help
DataStage not using the oracle table index
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 72
- Joined: Wed Dec 12, 2007 2:29 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: