| Use of Hints in Toad [message #327535] |
Mon, 16 June 2008 16:55  |
victory_nag
Messages: 36
Registered: June 2008
Location: CA
|
Member |
|
|
I am writing query
Select /*+ Paraller (emp,6)*/ name, ssn, id from emp ;
but the Hint given in toad is considered as a comment.
can you help me resolve the issue.
|
|
|
|
| Re: Use of Hints in Toad [message #327542 is a reply to message #327535] |
Mon, 16 June 2008 17:51  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
"Paraller" is not a valid hint.
Also, I think there shouldn't be a blank between the + and the hint itself for it to be recognized.
|
|
|
|
|
|
| Re: Use of Hints in Toad [message #327571 is a reply to message #327535] |
Mon, 16 June 2008 23:32 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
In addition, a hint IS a comment from SQL point of view.
It is just a special comment that is analyzed by Oracle optimizer.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
