Home » SQL & PL/SQL » Client Tools » Use of Hints in Toad
Use of Hints in Toad [message #327535] Mon, 16 June 2008 16:55 Go to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3189
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 #327564 is a reply to message #327542] Mon, 16 June 2008 22:46 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The blank after the /*+ is ok, as long as there is no blank between the /* and the +
Re: Use of Hints in Toad [message #327571 is a reply to message #327535] Mon, 16 June 2008 23:32 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Installing 10g client
Next Topic: Connection Problem with TOAD
Goto Forum:
  


Current Time: Mon Dec 05 09:11:30 CST 2016

Total time taken to generate the page: 0.07531 seconds