From oracle-l-bounce@freelists.org Wed Jul 21 16:22:18 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6LLM3E16755 for ; Wed, 21 Jul 2004 16:22:13 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6LLLr616739 for ; Wed, 21 Jul 2004 16:22:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D48872E537; Wed, 21 Jul 2004 16:01:08 -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 08695-100; Wed, 21 Jul 2004 16:01:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B097672D78B; Wed, 21 Jul 2004 16:01:07 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 21 Jul 2004 15:59:41 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 296F872C0A5 for ; Wed, 21 Jul 2004 15:59:41 -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 09046-31 for ; Wed, 21 Jul 2004 15:59:41 -0500 (EST) Received: from smtp808.mail.ukl.yahoo.com (smtp808.mail.ukl.yahoo.com [217.12.12.198]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 7FC6A72C022 for ; Wed, 21 Jul 2004 15:59:40 -0500 (EST) Received: from unknown (HELO Primary) (oracle-l@freelists.org@217.42.79.76 with poptime) by smtp808.mail.ukl.yahoo.com with SMTP; 21 Jul 2004 21:25:43 -0000 Message-ID: <018001c46f69$47fb3070$7102a8c0@Primary> From: "Jonathan Lewis" To: References: <6.1.0.6.2.20040721150743.02ec01d8@pop.centrexcc.com> Subject: Re: Creating Histograms Date: Wed, 21 Jul 2004 22:25:44 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5702 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Note in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated July 20th ----- Original Message ----- From: "Wolfgang Breitling" >> Otherwise I practice "plan stability" meaning "if the statistics >> don't change, the plans won't". Beg to differ - for example: The fixed predicate: last_update_date >= "calculated constant of 28 days ago" is likely to have a selectivity that changes as time passes, with a possible change in plan, precisely BECAUSE the statistics haven't changed. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------