RE: How to make query avoid using histograms

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 26 Apr 2005 18:50:07 +0200
Message-Id: <20050426165004.0CD5B8010FCD@smtp-out1.tiscali.nl>

you can't -- if histograms are available, they will be used. of course, you can use various hints and/or session settings to influence the optimizer.
just out of curiosity: why would you, in the presence of histograms, ever want to tell the optimizer *not* to use them?

kind regards,

Lex.  

---

Visit my website at http://www.naturaljoin.nl

---

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya
Sent: Tuesday, April 26, 2005 18:35
To: Oracle Discussion List
Subject: How to make query avoid using histograms

Any hints? 9204.
thanks in advance
Raj

---

select standard_disclaimer from company_requirements where category = 'MANDATORY';
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 26 2005 - 12:54:21 CDT