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