RE: multiple hints

RE: multiple hints

 

  

With a blank.

Thanks and Regards,
Satheesh Babu.S
Bangalore.






-----Original Message-----
From: genegurevich
[mailto:oracledba-ezmlmshield-x52837574.[Email address protected]
Sent: Thursday, September 29, 2005 4:45 AM
To: LazyDBA Discussion
Subject: multiple hints

I'm sure this is a simple question, but I can't keep it in my head. If I
want to do multiple hints for the same query,
do I separate them with blanks or commas?

select /*+ append norewrite */

OR

select /*+ append, norewrite *?

thank you

Gene Gurevich




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page