Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: histograms

Re: histograms

From: jaromir nemec <jaromir_at_db-nemec.com>
Date: Wed, 13 Sep 2006 18:07:13 +0200 (CEST)
Message-ID: <35844.213.162.65.17.1158163633.bloek@pwebmail.utanet.at>


Hi,

> A capital letter would fit rule 3, but watch out for rule 5 (your SQL
> may be massaged).
>

a possible way to avoid this is to use a hint like comments, i.e.

select /*+ option1 */ ..
select /*+ option2 */ ..

will remain (in my observation of 10g r2) two different statements. There is still some respect of hints in the parser:)

Regards,

Jaromir

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 13 2006 - 11:07:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US