RE: How to make query avoid using histograms
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <rjamya@xxxxxxxxx>, "'Oracle Discussion List'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 18:50:07 +0200
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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';
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
