From oracle-l-bounce@freelists.org Tue Apr 26 12:54:21 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3QHsKDZ015030 for ; Tue, 26 Apr 2005 12:54:20 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3QHsK4Z015026 for ; Tue, 26 Apr 2005 12:54:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C73DD1870AC; Tue, 26 Apr 2005 11:51:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26029-07; Tue, 26 Apr 2005 11:51:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4695618703E; Tue, 26 Apr 2005 11:51:54 -0500 (EST) From: "Lex de Haan" To: , "'Oracle Discussion List'" Subject: RE: How to make query avoid using histograms Date: Tue, 26 Apr 2005 18:50:07 +0200 MIME-Version: 1.0 Content-type: text/plain X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcVKfh1tuS1VfhRjRrKN6c9dV35zjQAAZsnA In-Reply-To: <9177895d050426093549f8ffad@mail.gmail.com> Message-Id: <20050426165004.0CD5B8010FCD@smtp-out1.tiscali.nl> Content-Transfer-Encoding: 8bit X-archive-position: 19033 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lex.de.haan@naturaljoin.nl Precedence: normal Reply-To: lex.de.haan@naturaljoin.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.63 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@freelists.org [mailto:oracle-l-bounce@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