Hi,
Can we use hints in SQL query in OCI stage? If I specify a parallel hint for a select query (which does a full table scan),will datastage read faster?
Regards,
Ayan
using hint in OCI stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To put that another way, DataStage itself does not use hints. So whether hints will make anything faster depends solely on whatever impact the hints will have in the database.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.